Saving to Excel 97-2003 in compatibility mode for

[Administrator]

We have a requirement to generate spreadsheets based on data in a database. The data in the spreadsheets must be grouped and the spreadsheet must be readable by Excel 2000.

If I use XlsIO to create a spreadsheet in Excel 2007/2010 format with a Pivot table, then open the spreadsheet up in Excel 2010 and save it in 97-2003 format the Pivot Table grouping and functionality is preserved when opened up with Excel 2000.

However, if use the following code to programatically save the spreadsheet in 97-2003 formatting the resulting xls file loses all grouping and Pivot Table functionality:

//Saving the workbook to disk.
workbook.SaveAs("Sample.xlsx");

//Close the workbook.
workbook.Close();

IWorkbook oldFormatWorkbook = application.Workbooks.Open("sample.xlsx");

oldFormatWorkbook.Version = ExcelVersion.Excel97to2003;
oldFormatWorkbook.SaveAs( "Sample for Excel 2000.xls" );
oldFormatWorkbook.Close();

Do know of any solution for this?

Thank you,

Keith

[Zakeer Ahmed S]

Hi Keith,

Thank you for using Syncfusion products.

Currently in our XlsIO, we do not support to parse the pivot table in Excel 2007 and Excel 2010 format, instead we read the pivot table as stream and serialize it. So, currently it is not possible to resave the Excel 2007/2010 to Excel 2003 file format. Please see the below online documentation for more details.

Currently, we do not have any plans to implement this feature.

The following is the Pivot Table support provided in our XlsIO

- Pivot table in existing document can be preserved for Excel 2003 format
- Creation of pivot table is supported in Excel 2007 format,

Online Documentation:
http://help.syncfusion.com/ug_83/Reporting/XlsIO/ASP.NET/Documents/pivottables.htm

Please let us know if you have any queries.
Regards,
Zakeer Ahamed. S