Cells
The Excel Export component supports options for customization of the cells that will be exported to Excel.
You can specify the options for the following types of cells:
- Header padding cells
- Padding cells
- Header cells
- Data cells
- Group header cells
- Group footer cells
- Footer cells
Header Padding Cells
The header padding cells are the cells that are inserted before the header cells to align the headers and the column values when the data is grouped.
To specify custom options, set the headerPaddingCellOptions property of the <kendo-excelexport> component.
Padding Cells
The padding cells are the cells that are inserted before the data, group, and footer cells to indicate the group hierarchy if the data is grouped.
To specify custom options, set the paddingCellOptions property of the <kendo-excelexport> component.
Header Cells
To specify custom options for a column-header cell, set the headerCellOptions property of the <kendo-excelexport-column> or <kendo-excelexport-group-column> component.
Data Cells
To specify custom options for a column data cell, set the cellOptions property of the <kendo-excelexport-column> component.
Group Header Cells
To specify custom options for a group header cell of a column, set the groupHeaderCellOptions property of the <kendo-excelexport-column> component.
Group Footer Cells
To specify custom options for a group footer cell of a column, set the groupFooterCellOptions property of the <kendo-excelexport-column> component.
Footer Cells
To specify custom options for a column footer cell, set the footerCellOptions property of the <kendo-excelexport-column> component.