Hi guys,
We have to modify a single worksheet in a quite large Excel spreadsheet. The size of this Excel spreadsheet is about 200Mb on disk and it doesn't contain any charts, pictures or formulas. It just contains 15 million decimal values distributed across 20 worksheets.
The problem is that Aspose needs about 900Mb of memory to load this Excel spreadsheet into a Workbook object, whereas Microsoft Excel 2003 or 2007 is happy with just 250Mb.
In order to decrease the memory consuption, and given that we just need to modify a single worksheet, we took the approach to load a single worksheet by using the SheetIndexes property in the LoadDataOptions as described here:
http://www.aspose.com/community/forums/314453/direct-to-file-mode/showthread.aspx
However, after finishing our modifications on the worksheet and saving the Workbook object into the Excel file then the data in the other worksheets is all lost. The worksheets in this saved Excel spreadsheet are all empty but the one we've selected in the LoadDataOptions. We're not sure whether we're doing something wrong or whether the purpose of the LoadDataOptions is just to load partially an Excel spreadsheet without any intentions to save the changes back.
Therefore, is it Aspose capable to modify large Excel spreadsheets or shall we just look for a different solution?
Thanks.
Ben.
