We are trying to load an excel (xlsx) file with data in columns A - CI and over 200,000 rows.
It fails with an out of memory exception.
How do we load/save large excel files?
We are trying to load an excel (xlsx) file with data in columns A - CI and over 200,000 rows.
It fails with an out of memory exception.
How do we load/save large excel files?
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
Please download and try the latest version:
Aspose.Cells
for .NET v7.1.1.5
If the problem occurs again, please provide us your source file throwing exception.
Please also share your Sytem/Runtime Environment.
If the out of memory error is thrown while saving workbook (e.g Workbook.Save), you may try to set SaveOptions.CachedFileFolder
while saving the workbook/file. When this option is not set, we have to
save something to memory first, then save to the file. Setting this
option will directly save to the file.
Please see the sample code below
VB.NET
OR
The problem is not in saving. If we have an xlsx file over 100meg the Aspose Workbook process goes abve 2 gig in memory usage. Then we get out of memory. Are you able to load large xlxs files?
Hi,
Aspose.Cells for .NET itself does not have any limitation of loading files. The bigger you create the Excel file, the more memory you may require.
Also, if your file has lot of images then those images will also take lot of memory.
a) - If you just want to load data of one worksheet, please try the following code with the latest version: Aspose.Cells
for .NET v7.1.1.5
Please download the source.xlsx file from the given link to try this code.
C#