ExcelExportProperties

16 Dec 20251 minute to read

The event argument that holds configuration details for exporting Pivot Table data to Excel.
This interface extends the base GridExcelExportProperties and includes additional options
specific to Pivot Table export, such as targeting multiple Pivot Table instances by ID.

Properties

columns Column[]

Defines the columns which are to be customized for Export alone.

dataSource Object|DataManager

Defines the data source dynamically before exporting

enableFilter boolean

Defines filter icons while exporting

exportType ExportType

Indicates to export current page or all page

fileName string

Defines the file name for the exported file

Defines the footer content for exported document

Defines the header content for exported document

includeHiddenColumn boolean

Indicates whether to show the hidden columns in exported excel

multipleExport MultipleExport

Exports multiple grid into the excel document

pivotTableIds string[]

Defines the IDs of the Pivot Table instances to be exported to Excel.
Multiple Pivot Tables can be exported by specifying their element IDs in this array.

query Query

Defined the query dynamically before exporting

separator string

Defines the delimiter for CSV file export

theme ExcelTheme

Defines the theme for exported data