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?
Discussion posts and replies are publicly visible
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?
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?
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
This is solved now. This was a plugin issue, since the code was old, on Modify workflow, deprecated Export SQL to Excel is used that is why this error was showing up when executing Modify workflow.
Please check precedents and make sure plugins are aligned if this issue occurs for anyone.