ExcelExportProperties API in Angular Grid API component

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

string

Indicates to export current page or all page

fileName

string

Defines the file name for the exported file

footer

ExcelFooter

Defines the footer content for exported document

header

ExcelHeader

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

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