System.ArgumentException: 'Invalid end row index.

[adoghezzi]

I have some files all with one workbook and one workshet

implementing
Excel-Merge-Merge-Excel-Files-into-One

FreeSpire.XLS 14.20

I'm trying to merge into one file with one workbook and all worksheet
each below he othe
atfile 107 line
currentRange.Copy(destRange);
get the exception
=>System.ArgumentException: 'Invalid end row index.'

data at line are

currentRange.CombinedAddress
"'Box150'!$A$2:$F$10084"

destRange.CombinedAddress
"'AC8A0'!$A$1047390"


Ia there a solution or it is alimit ?

more wich objet is exceprion related
currentRange or (destRange

[Doris.Liu]

Hi,

Thank you for your message.
Our free version is limited to 5 sheets per workbook and 200 lines per sheet. And we rarely maintain the free version. I recommend that you download our latest commercial version 14.4.7 from the link below for testing, as the commercial version contains more fixes. We would like to offer you a one month free trial license that will help you remove limitations and evaluate watermarks, please contact us if you need it!

Spire.XLS 14.4.7: https://www.e-iceblue.com/Download/down ... t-now.html

Sincerely,
Doris
E-iceblue support team

[adoghezzi]

Thankyou for your reply

Before sstarting the project I checked license model and documentation
It seems that limitations on Free version were removed.

But anyway please let me have a Trial License

Thanks

[Doris.Liu]

Hi,

Thank you for your response.
Please apply for a temporary license from the link below. If you are still having problems after applying the license, please provide test files for us to investigate further. If you don't want to publicize the files in the forum，please send them to '[email protected]'. Thanks in advance!
https://www.e-iceblue.com/TemLicense.html

Sincerely,
Doris
E-iceblue support team