Convert xlsx to xml, but when the number of rows exceeds 65535, some data is lost

Aspose.Cells Product Family
1

I refer to the link below to convert Excel to xml format. When the number of rows exceeds 65535, the data after 65535 rows is lost.

Version info:

Aspose.Cells for Net 23.9

2

@sullivan,

Please note, XML Spreadsheet file format (SpreadsheetML) itself has limits which can save a maximum of 65,536 rows and 256 columns. That’s why data records after 65536 would be lost.

But you may try to cope with it by ignoring this limits in code, see the following sample code for your reference.

Workbook workbook = new Workbook(filePath);
SpreadsheetML2003SaveOptions opts = new SpreadsheetML2003SaveOptions();
opts.LimitAsXls = false;
workbook.Save(filePath + ".out.xml", opts);