Free Support Forum - aspose.com

Problems with saving to SpreadsheetML

Hi,



I have a spreadsheet (attached) that can not be opened when it is saved in SpreadsheetML.



Here’s my code:



public void AsposeTest()

{

var workbook = new Workbook();

workbook.Open(“C:\block_formatting.xls”, FileFormatType.Default);



workbook.Save(“C:\block_formatting.xml”, FileFormatType.SpreadsheetML);

}



And when I open the SpreadsheetML, here’s the error I got:



XML ERROR in Worksheet Setting

REASON: Bad Value

FILE: C:\block_formatting.xml

GROUP: Worksheet

TAG: Table

ATTRIB: ExpandedColumnCount

VALUE: 255



Some tips:



When we manually set the ExpandedColumnCount in the SpreadsheetML to 256, it will work.



btw, I’m using the Aspose.Cells in .NET.



-Steve

Hi,

Thanks for providing us the template file.

We found the issue after an initial test, we will figure it out soon.

Thank you.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached version.

Thank you.