[Advanced Excel] [Advanced Excel] Error using Cell_WriteRange to write data

Forge Component
(58)
Published on 2019-08-27 by Hanno
58 votes
Published on 2019-08-27 by Hanno

Hi guys,

I used to write data in excel file with the action [Cell_WriteRange] in the [Advanced Excel] extension. But i got a werid error. 

it works pretty good when i have written  4 or 5 recordlists. But when i want write one more recordlist data, i get the error: "Specified argument was out of the range of valid values.Parameter name: Start cell Address must be less or equal to End cell address". It seems that the Start cell address is less to then End cell. But after i checked the data, it shows the data is fine.

I have searhed the problem in community, and i got this:

https://www.outsystems.com/forums/discussion/10320/error-using-2-cell-writerange-to-same-sheet/

I have tried to update the verion for Epplus.dll file from 4.1.0.0 which i used to the lastest version 4.5.3.2, but i still can get the werid error.

Does anyone meet this or have solution for this?

Here is the error screenshot:

Solution

Zhuang, I'll send you my email address in a PM so I can help you look into this.

Hanno

Solution