Tue Jun 13, 2017 7:50 am
Dear Philip,
After further investigation, we found that the file will not be opened successfully by MS Excel, see the screenshot on attachment.
Then we found the file has 1799255 rows, but the maximum limit for the version07 or above is 1048576 rows. Please kindly note that our Spire.XLS is MS Excel standard-based. So you will get “Specified argument was out of the range of valid values” exception when the memory is enough.
In addition, as I said before, if you're loading huge document into Spire.XLS' DOM, more memory would be required. This is because during processing, the document needs to be held wholly in memory. Usually, Spire.XLS needs 10 times more memory than the original document size to build a DOM in the memory. You will get the “OutOfMemory” exception when the Memory usage is not enough.
For your issue, we suggest you reduce the size of your document.
Sincerely,
Betsy
E-iceblue support team
- Attachments
-
- MS Excel.png (14.61 KiB) Viewed 3651 times