Skip to main content
ashwini.nemade
ashwini.nemade
March 16, 2024
Question

Export to Excel function: Attempting to write a row[4] in the range [0,157943] that is already written to disk error

  • March 16, 2024
  • 4 replies
  • 0 views

I am getting this error on Export to Excel function when I am exporting the data in excel via SQL query- 

The following error was raised by the Export to Excel function: Attempting to write a row[4] in the range [0,157943] that is already written to disk.

We have this functionality where there is a Create and Modify workflow and we want to create a excel template in both scenarios using SQL query.

The strange thing is  - We are using same excel base template on both Create and Modify workflow but this error only occurs when executing Modify workflow.

We have formula on A column which is populated on 4th row and excel headers till 3 rows so the starting cell is B5. 

Can anyone please help me out to understand the root cause here?

4 replies

davidj137213
davidj137213
March 16, 2024

Seems to be related to some bug in the library used when working with certain types of Excel files...

I had this error in the past (not in Appian), and solved it by removing duplicate rows and dynamic headers. Could you try removing them if it were your case?

ashwini.nemade
ashwini.nemadeAuthor
March 17, 2024

Hi David, did you do this in the plugin code? Since I am using Appian plugin - Export Excel, I dont have access to the code. Is there any way we can handle this on Appian side?

davidj137213
davidj137213
March 17, 2024

No,  I did that in Java, (I wasn't working with Appian in that moment).

From Appian side, i would suggest to implement your own function (is not complicated) , or just try removing some data from your excel (dynamic rows or duplicate values), in order to identify which one is causing the problem

Terms & ConditionsAccessibility statement