Report Format Type - Excel

The most commonly used Report Format Type is Excel, where the exported data can be opened in Excel.

This option is only available if the ExcelExportModule AG Grid Module is loaded

When using this option only the downloadable File System Export Destination is available (i.e. the data cannot be sent to the Clipboard).

Users are able to create a Custom Export Destination, e.g S3, and then export the Excel formatted data there

Excel Column Types

AdapTable allows developers to define in AG Grid, columns which have a particular Excel Data Type.

This ensures that Excel will render that column using the correct type.

This only affects the behaviour in Excel for exported data
There is no impact on how AdapTable (or AG Grid) renders the Column or formats the Cells

There are 4 types of Column Data Types supported

This are configured using the cellClass property in the ColDefs object (which is an array), e.g:

cellClass: ["stringExcelType"]

This can very occasionally result in the column losing any formatting which it has been given in AdapTable

Excel Column Type

In this example we configure 2 Columns with Excel Column Types:
- Rating - has a stringExcelType
- Price - has a numberExcelType

Try It Out

Export to Excel and note that the Price column is of type Number and the Rating column shows all values as strings