We're evaluating Apose Cells as a mechanism for the automated conversion of MS Office 2010/2007 xlsx files to Office 2003 format and have encountered the exception "Unsupported PivotTable source type" when calling the Save method of the Workbook object.
This is when using Apose.Cells.dll for the .Net 3.5 client profile, which displays a version of 7.2.1.0. At present the application code is nothing more than an instantiation of the Workbook class passing the source xlsx file name followed by a call to the Save method specifying the SaveFormat of Excel97To2003 (no document contents are modified between these calls.)
The Microsoft automatic conversion add-in for Office 2003 seems able to convert the same xlsx file correctly.
Is there anyhting we can do to prevent this exception? Failing that, is there any way of predicting whether or not Save will succeed before calling it is there a documented list anywhere of the features that are certain to cause conversion failure?
Thanks for any advice you can give.
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
If your .NET framework is not client profile, then you must not use the 3.5 client profile dll.
Please use the DLL under the directory “net2.0” and not “net3.5_ClientProfile”.
And please check the readme.txt under the directory
“Bin”.
Please see the below image for more help.
Please download and use the current latest 2.0 dll:
Aspose.Cells for .NET (Latest Version)
and use it and see if it resolves your problem.
If the problem still occurs, please provide us your complete source code and source xls/xlsx file replicating this bug.
We will look into it and help you asap.
Screenshot:
I've tried using the .Net2.0 V7.2.2.2 release, but got the same results. I've attached an example file that will convert using the Microsoft converter add-in and therefore open in Excel 2002, but that raises the "Unsupported PivotTable source type" exception in Aspose Cells.
The code used to reproduce this is trivial, and consists of:
Workbook wbk = new Workbook(@"c:\temp\PTAClean.xlsx");
wbk.Save(@"c:\temp\PTAClean.xls", Aspose.Cells.SaveFormat.Excel97To2003);
Hopefully this can be resolved, because we would like to start acceptance testing of an app that uses Cells (and Words) very soon (in the next week.)
Hi,
Thanks for your posting and providing us the needed files.
You are right.
I was able to replicate this issue using the latest version:
Aspose.Cells for .NET (Latest Version)
We have logged this issue in our database. We will soon look into this issue and once the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-40801.
Screenshot: