Cells
The saveExcel method supports options for customizing the cells that will be exported to Excel.
You can specify the following options for the file that will be exported:
- 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 in the object passed to the saveExcel method.
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 in the object passed to the saveExcel method.
Header Cells
To specify custom options for a column-header cell, set the headerCellOptions property when defining a selected column.
Data Cells
To specify custom options for a column data cell, set the cellOptions property when defining a column.
Group Header Cells
To specify custom options for a group header cell of a column, set the groupHeaderCellOptions property when defining a column.
Group Footer Cells
To specify custom options for a group footer cell of a column, set the groupFooterCellOptions property when defining a column.
Footer Cells
To specify custom options for a column footer cell, set the footerCellOptions property when defining a column.