reactjs - Exporting all columns(including hidden) in an Ag grid react

Question

I want to be able to export my AG grid to CSV so that it includes the hidden columns in the export. When I right click on the grid to export it only exports the visible columns (not the hidden ones). I know there is an API call I can make which will allow me to export all columns, but is there a way of exporting all by using the built in export functionality (right click).

question from:https://stackoverflow.com/questions/65921114/exporting-all-columnsincluding-hidden-in-an-ag-grid-react

Answer 1

You need to set your defaultExportParams which are the params used for the export when exporting via right click. Set the property allColumns to true in these params, and it should export all columns, including hidden columns.

See here for the list of available properties for defaultExportParams.

Demo