We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Saving to Excel 97-2003 in compatibility mode for

Thread ID:

Created:

Updated:

Platform:

Replies:

97293 Nov 15,2010 08:06 PM UTC Nov 16,2010 02:05 PM UTC Windows Forms 1
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On November 15, 2010 08:06 PM UTC

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 [Syncfusion]
Replied On November 16, 2010 02:05 PM UTC

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



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;