Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I have attached an XLS that contains only simple text, but it has a large number of rows. While the XLS is only 4MB on disk, it is plain text that has 20,000 rows and 10 columns. I understand that the size in memory could be much greater. Simply opening the worksheet fails with an out of memory exception: Exception of type 'System.OutOfMemoryException'.
We are using SheetRender and Aspose Cells 22.214.171.124. The code sample we are using can be seen in the thread, “SheetRender Creates Blank Pages But Excel Does Not”.
The XLS displays fine in Excel. We realize that there may be some memory limitations that may make opening a worksheet with a large number of rows a problem.
Could you try opening this XLS?
Do you think we should we able to open this XLS?
What should we use as a guideline to define the limitations on the size of the XLS?