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?<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /><o:p></o:p>