Aspose.Cells V4.7.0(evalution version) Conversion from Excel file to SpreadsheetMLand SpreadsheetMLto Excel

Aspose.Cells Product Family
1

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.

2

Hi,

Could you post your template excel file(s) here, we will check your issue soon.

Thank you.

3

Hello, Amjad,

I've attached 2 sample files. Thanks for looking into this.

4
monty:

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.

When saving Excel2003 file to SpreadsheetML in MS Excel, all charts will also be lost. This is the limitation of MS Excel. Your can verify it in MS Excel.

There is a pivot table in second sheet. Currently we only preserve it in Excel2003 file and cannot parse it. So saving it to SpreadsheetML, the pivot table settings are lost.

monty:

2. Excel2007 file to SpreadsheetML

Exception error: Index out of range.

We are checking it and will reply you soon.

5

Hi,

Please try the attached version (4.7.0.2), we have fixed "Index out of range" issue.

Thank you.

6

The issues you have found earlier (filed as 7728) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Amjad Sahi.