I am currently using the demo version of Aspose Excel version 3.5.3.0. I have run into a problem where a 2nd save creates a blank excel file. Here is some sample code:
Dim stream As New System.IO.MemoryStream(data) _excelDocument = New Aspose.Excel.Excel _excelDocument.Open(stream) _excelDocument.Save("c:\temp\1.xls") _excelDocument.Save("c:\temp\2.xls") _excelDocument.Open(stream) _excelDocument.Save("c:\temp\3.xls")
1.xls and 3.xls look fine. But 2.xls looks blank (except for the Evaluation Copyright Warning of course). Any ideas?
When calling Excel.Save method, many intermedia data are changed and many state data are updated. For performance consideration we don't roll them back. So we discard data to avoid problems.
If you want to preserve data, please use Excel.Copy method to make a copy before saving.