Hi,
Thanks for your inquiry.
Pivot table could work in Excel 2007 Version. Please try the code below to set the Excel file version as Excel 2007 Version.
- Code: Select all
//Set the Excel file version as Excel Version 2007
Workbook workbook = new Workbook();
workbook.Version = ExcelVersion.Version2007;
If the code couldn’t solve your issue, to help us better investigate it, please offer us the following information.
1. Your input Excel file(if any);
2. The complete code you were using which could reproduce your issue directly.
You could upload them here or send us(
support@e-iceblue.com) via email.
Best wishes,
Amber
E-iceblue support team