HI Aspose Team,
There are 2 problems when I convert from Excel file to SpreadsheetML and then SpreadsheetML to Excel.
1. Excel2003 file to SpreadsheetML and then from this SpreadsheetML to Exel2003 file
Issue: dropdown list on 2nd sheet and bar chart on 3rd sheet all missing in the final Excel2003 file.
2. Excel2007 file to SpreadsheetML
Exception error: Index out of range.
Below is my sample code:
Aspose.Cells.Workbook wb1 = new Aspose.Cells.Workbook();
wb1.Open("c:\\temp\\SampleExcelFile_XLS.xls",Aspose.Cells.FileFormatType.Excel2003);
wb1.Save("c:\\temp\\SampleExcelFile_XLS_SpreadsheetML.xml", Aspose.Cells.FileFormatType.SpreadsheetML);
Aspose.Cells.Workbook wb2 = new Aspose.Cells.Workbook();
wb2.Open("c:\\temp\\SampleExcelFile_XLS_SpreadsheetML.xml", Aspose.Cells.FileFormatType.SpreadsheetML);
wb2.Save("c:\\temp\\SampleExcelFile_XLS_SpreadsheetML_XLS.xls", Aspose.Cells.FileFormatType.Excel2003);
Aspose.Cells.Workbook wb3 = new Aspose.Cells.Workbook();
wb3.Open("c:\\temp\\SampleExcelFile_XLSX.xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx);
wb3.Save("c:\\temp\\SampleExcelFile_XLSX_SpreadsheetML.xml", Aspose.Cells.FileFormatType.SpreadsheetML);
Aspose.Cells.Workbook wb4 = new Aspose.Cells.Workbook();
wb4.Open("c:\\temp\\SampleExcelFile_XLS_SpreadsheetML.xml", Aspose.Cells.FileFormatType.SpreadsheetML);
wb4.Save("c:\\temp\\SampleExcelFile_XLSX_SpreadsheetML_XLSX.xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx);
The source Excel file has 3 sheets and on the 3rd sheet, there is a bar chart.
Let me know how can I solve this.
Thanks a lot.