The grid data can be exported to following:

  1. Excel file with xlsx extension.
  2. csv
  3. Html
  4. Json
  5. Zip file.

The following are automatically supported:

  1. Export of merged cells.
  2. Export of grouped rows
  3. Export of grouped columns
  4. Export of filtered rows.

Format and content of exported file can be controlled at 2 levels.

Declarative:

Please check the API for details of these common options and parameters.
Column options:
  1. column.copy
  2. column.hidden
  3. column.exportRender
  4. column.format
exportData() parameters
  1. render
  2. noheader

Imperative:

  1. column.render
  2. ui.Export in column.render
  3. javascript workbook: This is available for Excel export only. Any customization which is not possible through options and parameters alone can be done at this stage programmatically by altering the javascript workbook itself. it opens up lot of possibilities like combining of multiple worksheets, add custom content, formatting to any cell. In order to do this, you need to understand the structure of workbook.