We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Data gets lost with LoadOption

Hi,

i use your code regarding LoadOptions to open a big workbook and
change a single cell.

Unfortunatly the content of all other sheets get lost after saving.
Is it possible to save this data, too ? I don’t need to recalculate.

I don’t want to load the whole workbook because it takes too long and
i want to do only a small change.

Can you help me ?

Regards,
Guido

Hi,


Well, yes, sure the contents in other worksheet (apart from your loaded worksheet) would be lost. The LoadDataOption will load only your specific sheet(s) which you specify in SheetNames attribute, all other worksheets will be not be either loaded or saved with the file. In short, if you load a single sheet (via LoadDataOption) and update a cell value (for which other sheets might be effected, e.g some formulas might be updated in other worksheets etc.), this change will not have any impact at all as when you save the file only your loaded worksheet(s) would be saved.

By the way, could you share the Excel file, we will check how minimize the time of loading

Also, could you try our latest version if it enhances the loading time: Aspose.Cells for .NET v7.3.5.3


Thank you.