[Advanced Excel] Error using 2 Cell_WriteRange to same Sheet
Question
excel-png
Web icon
Forge component by Carlos Freitas
Hello,

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.
mvp_badge
MVP
any ideas yet?


I'm encountering the same issue
mvp_badge
MVP
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 ?

mvp_badge
MVP

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

If anyone having solution please share.

mvp_badge
MVP

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.


Regards

-PJ-

This is an old thread, but just wanted to add something as a future reference: 

If your record list is empty (or the range falls short for some records) and you use actions like CellFormat_ApplyToRange or Worksheet_AddAutoFilter without applying some checks, you might get this same error. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.