Hi
Workbook book = new Workbook(<SampleFile>);
book.Save(<NewFile.xml>", SaveFormat.SpreadsheetML);
Hi
Workbook book = new Workbook(<SampleFile>);
book.Save(<NewFile.xml>", SaveFormat.SpreadsheetML);
Hi Mukundan,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue. After converting your source xlsx file into SpreadsheetML, the data after 256th column is lost.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-42563.
I have attached output file and the screenshot for a reference
Hi Mukundan,
Thanks for using Aspose.Cells.
Please set SpreadsheetML2003SaveOptions.LimitAsXls property as false to fix this issue.
Please see the following code for your reference.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\SampleFile.xlsx”;
Workbook workbook = new Workbook(filePath);
SpreadsheetML2003SaveOptions opts = new SpreadsheetML2003SaveOptions();
opts.LimitAsXls = false;
workbook.Save(filePath + “.out.xml”, opts);
Hi Shakeel
Hi Mukundan,
Thanks for your feedback and using Aspose.Cells.
It is good to know that your issue is fixed with the given code. Let us know if you encounter any other issue, we will be glad to look into it and help you further.