Open pivot grid in Aspose.Cells.GridDesktop

Aspose.Cells Product Family
1

Hi

Is it possible to open an “Excel file with Pivot” and “Excel with Data connection” with in Aspose.Cells.GridDesktop.GridDesktop. Using “gridDesktop1.ImportExcelFile(“C:\Pivot Excel.xls”);” I am able to load simple excel and it is working. Formula columns are also working fine.
But if I try to open Pivot table the pivot function is not working. The attached Excel is having pivot function in “sheet3”. It is not working. Can you help on this?

2

Hi,

Thanks for the template file.

I am afraid, the feature is not supported. The Pivot Tables would only be rendered as static reports when you import a template file containing PivotTables into GridDesktop control.

By the way, if you need to manipulate PivotTable reports (without UI) on the fly, you may use our other component i.e. Aspose.Cells (library) which is powerful enough to create load/read and manipulate Pivot tables, you may save the updated files on the disk/stream if you want, see the documents in the section for your reference:

http://www.aspose.com/docs/display/cellsnet/Working+with+Pivot+Tables

Thank you.

3

Thanks for you quick reply.