Hello together,
I have in my QlikView Applications severals Pivottables. I want to export the data of the Pivottable by C# OCX. Now I have the problem that I get not the full table data, some columns are collapsed, how can I open these columns automatically.
Application qvApp = new Application();
Doc qvDoc = qvApp.OpenDoc(@"PATH_TO_QV_APP");
//get object
SheetObject qvObject = qvDoc.GetSheetObject("QV_OBJECT_ID");
// cast object to pivottable
PivotTableBox pivottable= (PivotTableBox)qvObject;
//file path to save
pivottable.Export("FILE_PATH", ";");