Use Excle2002 xml data to create an excel 2000 xls file

Aspose.Cells Product Family
1

I have a web application, where i can get the Excel2002 xml data with all the data and formating on the front end using javascript, but one of the customer is using Excel 2000, so i need to allow them to save the data as Excel2000 xls file locally. Is it possible to use Aspose.Cells to do what i need? i.e., given excel 2002 xmldata and save as excel2000 xls file.

Thanks a lot!

2

Hi,

Thanks for considering Aspose.

Well, yes, Aspose.Cells supports to open / save .xml (SpreadsheetML) file. You may simply open the xml file and convert to save as FileFormatType.Excel2000 enum.

Sample code:

Workbook workbook = new Workbook();

workbook.Open("TestBK.xml",FileFormatType.SpreadsheetML);

workbook.Save("MyBook.xls", FileFormatType.Excel2000, SaveType.OpenInExcel, Response);

For further ref, please check some wiki docs, e.g:

Opening Files

Saving Files

Thank you.

3

Aspose.Cells supports spreadsheetML(Excel2003 xml format) but doesn’t support Excel2002 xml data. So I think we cannot serve your need.

4

yeah. We are using SpreadsheetXML and Aspose.Cells helps to convert it to xls