[Advanced Excel] Error using 2 Cell_WriteRange to same Sheet

[Advanced Excel] Error using 2 Cell_WriteRange to same Sheet

Forge Component
Published on 24 Jul by Hanno Coetzee
27 votes
Published on 24 Jul by Hanno Coetzee

I need to write 2 tables in the same Sheet, so I'm using 2 Cell_WriteRange, one writing to Line=2/Column=1 (writes 2 columns) and other to Line=2/Column=5 (writes 4 columns), but 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 

If I write the second table to another sheet it works fine. I tried using a Worksheet_SelectByIndex for each Cell_WriteRange (all pointing to the same Sheet) but same error.

Any ideas?

Thanks in Advance.
any ideas yet?

I'm encountering the same issue
well I have sorted it by fixing it myself with a new action, since I had a recordlist of recorlists.

I'm having the same issue.. Any solutions?

Hi everyone,

I am also facing same issue .. Any Solution ?

It could be in the EPPlus library. Will need to debug and see what is happening there.

If anyone having solution please share.

Hi Shahsi,

I think you have the solution now as we discus , the dll was corrupted and when you replace it things start working fine.