Expand the columns while export pivot grid in Excel

[vijay@spinetechnologies]

Hi Paramvir,

I have applied a pqGrid with Pivot functionality. The columns of the pivot are in collapsed mode by default.

While exporting the grid, I want to expand the columns in the generated files. Currently, the collapsed columns are in the hidden format in the exported file.

For your reference, I am attaching a file.

[paramvir]

you can generate intermediate js workbook ( exportData method ) and make all the columns visible ( by iterating over every column ) before exporting workbook to xlsx file ( pq.excel.exportWb method )

[vijay@spinetechnologies]

Hi Paramvir,

I try to implement the above method but did not get the expected result.

Can you please provide me with an example of this method? It will help me a lot.

[paramvir]

Please check this example: https://paramquery.com/pro/demos/export_group_columns