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.