Cells

The Excel Export component supports options for customizing the cells that will be exported to Excel.

You can specify the options for the following types of 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 ExcelExport component.

Example
View Source
Edit In Stackblitz  
Change Theme:

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 ExcelExport component.

Example
View Source
Edit In Stackblitz  
Change Theme:

Header Cells

To specify custom options for a column-header cell, set the headerCellOptions property of the ExcelExportColumn or ExcelExportColumnGroup component.

Example
View Source
Edit In Stackblitz  
Change Theme:

Data Cells

To specify custom options for a column data cell, set the cellOptions property of the ExcelExportColumn component.

Example
View Source
Edit In Stackblitz  
Change Theme:

Group Header Cells

To specify custom options for a group header cell of a column, set the groupHeaderCellOptions property of the ExcelExportColumn component.

Example
View Source
Edit In Stackblitz  
Change Theme:

To specify custom options for a group footer cell of a column, set the groupFooterCellOptions property of the ExcelExportColumn component.

Example
View Source
Edit In Stackblitz  
Change Theme:

To specify custom options for a column footer cell, set the footerCellOptions property of the ExcelExportColumn component.

Example
View Source
Edit In Stackblitz  
Change Theme: