The grid provides in-built Excel (xlsx) export functionality without the need for any third party libraries. Exporting to Excel can be performed from the Context Menu or programmatically via the Grid API and the exported spreadsheets can be fully customised and styled to meet user requirements.
Enabling Excel Export
The enterprise version of the grid provides an 'Excel Export' option via the grids Context Menu by default. (If you are using Enterprise Modules ensure the
ExcelExportModule is registered.)
Excel export is also possible via the Grid API using the following method:
No special configurations or third party libraries are required for either approach.
Default Excel Export
The default Excel export behaviour will export the grid as it is currently rendered. This means the exported spreadsheet will match what is displayed in the grid at the time of export following any sorting, filtering, row grouping, columns visible, grouped columns etc...
Note that the raw values, and not the result from a cell renderer will be used, meaning the results from:
- Value Getters will be used.
- Cell Renderers / Formatters will NOT be used.
- Cell styles will NOT be exported by default.
In the following example reorder some columns and apply some filter and sort operations - then export from the 'Excel Export' option in the context menu, or the 'Export to Excel' button provided. Note the following:
- The current order of the columns is exported and any hidden columns will not be exported.
- Filtered out rows are not included in the export, and the sort order is maintained.
- The column width in Excel will be the same as the actual width of the column in the application at the time that the export happens, or 75px, whichever is wider. "Actual width" may be different from the width in the column definition if column has been resized or uses flex sizing. This can be overridden using the
- The data types of your columns are passed to Excel as part of the export so that you can work with the data within Excel in the correct format.
- The cells of the column header groups are merged in the same manner as the group headers in AG Grid.
Custom Excel Export
The Default Excel Export behaviour will meet the requirements of most applications. However, you can apply extensive customisation to the values exported, layout, value formatting and styling of the exported spreadsheets.
The sections below cover the various ways the exported Excel spreadsheets can be customised:
- Styles: Apply custom styling to exported spreadsheets
- Formulas: Export the grid's value getters to Excel formulas
- Extra Content: Add to the exported spreadsheets extra content not shown in the grid
- Images: Export images as extra content or within grid cells
- Multiple Sheets: Export grid data across multiple sheets of an Excel workbook
- Rows: Set which rows are exported
- Columns: Set which columns are exported
- Data Types: Export grid values to the Excel built-in data types.
- Hyperlinks: Add hyperlinks to exported spreadsheets.
- Master Detail: Export master detail grids to single or multiple sheets
- Page Setup: Customize the page setup of the exported spreadsheets
Continue to the next section: API Reference.