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

Free Support Forum - aspose.com

Get data in Excel file beyond 256 columns when converted to SpreadsheetML or XML in .NET

Hi

When I try to save an excel file with more than 256 columns, the data beyond 256 columns is not populating.
Sample code for the following
Workbook book = new Workbook(<SampleFile>);
book.Save(<NewFile.xml>", SaveFormat.SpreadsheetML);
The newly saved xml file doesn't have data beyond 256 columns.
Please look into this?
Also once we go over step 2 the workbook object loses the data after 256 columns so now even if we save the workbook into xlsx format the data loss is clearly evident.
I'm attaching the sample file for the same.
Thanks and regards
Mukundan

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

Thanks for the workaround.
It is working fine.
Thanks and Regards
Mukundan

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.