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
- 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 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 ExcelExport component.
Header Cells
To specify custom options for a column-header cell, set the headerCellOptions property of the ExcelExportColumn or ExcelExportColumnGroup component.
Data Cells
To specify custom options for a column data cell, set the cellOptions property of the ExcelExportColumn component.
Group Header Cells
To specify custom options for a group header cell of a column, set the groupHeaderCellOptions property of the ExcelExportColumn component.
Group Footer Cells
To specify custom options for a group footer cell of a column, set the groupFooterCellOptions property of the ExcelExportColumn component.
Footer Cells
To specify custom options for a column footer cell, set the footerCellOptions property of the ExcelExportColumn component.
