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.htmPlease let us know if you have any queries.
Regards,
Zakeer Ahamed. S