Framework:Javascript GridAngular GridReact GridVue Grid

Angular Grid: Excel Export - Columns

Excel Export allows you to select which columns get exported to Excel.

By default, all the columns in the grid are included in the Excel export. However, you can set which columns are exported to the Excel file.

Column Headers

By default column headers and group column headers are included in the Excel export. However, you can suppress the export for column header rows using the skipColumnGroupHeaders and skipColumnHeaders properties to true.

Note the following:

  • By default, all grouped column header rows and the column header row are exported.
  • Group Headers will be skipped if Skip Column Group Headers is checked.
  • Normal headers will be skipped if Skip Column Headers is checked.

Hidden Columns

By default, hidden columns are not included in the export. If you need all columns to be exported even if they're currently hidden in the grid, set the allColumns property to true.

Note the following:

  • By default, only visible columns will be exported. The bronze, silver and gold columns will not.
  • If All Columns is checked, the bronze, silver and gold columns will be included in the exported file.

Next Up

Continue to the next section: Data Types.