Hi,
I want to export RadPivotGrid to excel as collapsed rows and columns.
In the grid, it has many levels so it can be collapsed or expanded.
But after collapsed to top level, exporting in excel still shows the rows/columns which are not seen in
the grid. The GenerateExport() method in RadPivotGrid returns PivotExportModel which contains all
cells regardless of expanded or collapsed
Any
thoughts how to achieve this?
Thanks in
advance.
I want to export RadPivotGrid to excel as collapsed rows and columns.
In the grid, it has many levels so it can be collapsed or expanded.
But after collapsed to top level, exporting in excel still shows the rows/columns which are not seen in
the grid. The GenerateExport() method in RadPivotGrid returns PivotExportModel which contains all
cells regardless of expanded or collapsed
Any
thoughts how to achieve this?
Thanks in
advance.