Free Support Forum - aspose.com

Unable to create pivot for a excel

Aspose.Cells Product Family
#1

Hi,

I was trying one of your java programs for creating pivots. Since the program was unable to create the excel file in the first place i have made some changes to the program after which the problem was resolved. However the excel file opened with an alert

"Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

There was no data loss but the pivot for the excel file was not created. Please let me know what can be done to resolve the error.

Thanks & Best Rgds.

Vishal

PS: Program attatched...

#2

Hi Vishal,

Thanks for considering Aspose.

Well, I tested your code and found no problem at all. The pivot table is created fine.

Attached is the output file.

Which version of Aspose.Cells for Java you are using. Could you try the attached version.

Thank you.