HI
I have an existing xlsx file that has a pivot table. When I update the source data for the pivot table using Aspose.Cells and then try opening the updated file in Excel I get error message about content being unreadable.
When I open the file again in Aspose I get the following error:
System.NullReferenceException: Object reference not set to an instance of an objIf I save the file to the xls format the issue looks to go away.
ect.
at Aspose.Cells.Cells.CreateRange(String address)
at ←.?.↨☻(XmlTextReader )
at ←.?.(XmlTextReader )
at ←.?(XmlTextReader )
at ?.⌂.⌂☻()
at ?.⌂☻()
at ?.(Workbook , Stream , ▬ )
at Aspose.Cells.Workbook☻(Stream , LoadOptions )
at Aspose.Cells.Workbook…ctor(Stream stream)
I have included sample project that takes the source file and create the output file that has errors…
I have also included both the source and output file I am getting.
Any help or direction would be greatly appreciated