I used the ConsoleDemo.java in the Aspose Demo to generate a Excel 2003 file with a pivot table, and it works. But if I save to Excel 2007, the pivot table doesn’t show up when I open the Excel file with Excel 2007. All I change, is line 1921 in ConsoleDemo.java
Well, I am afraid; Pivot Tables feature is not yet supported for Excel 2007 file formats. We have already included this feature in our future development list with internal issue id: CELLSJAVA-13971. We will let you know when the feature is supported.
Well, I am afraid we cannot provide the ETA to finish this feature because it is complex and currently we are working on many tasks in parallel. So it is not possible for us to provide an ETA at the moment.
We supported the feature (create, manipulate and refresh Pivot Tables and shapes in XLS/XLSX (MS Excel 2007 - 2019)) with enhancements in newer versions. We recommend you to kindly upgrade to and give it a try to latest version of Aspose.Cells. Also, see the document for your reference: Create Pivot Tables and Pivot Charts
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.