Excel Export allows you to select which rows get exported to Excel.
By default, all the rows in the grid are included in the Excel export. However, you can set which rows are exported and configure how they are rendered within the Excel file.
By default, all visible rows are exported, but by using the
onlySelected param, only the selected rows will be exported.
By default Excel renders every exported value in a cell using a single line. If you need to display a cell value on multiple lines, please set the Excel Alignment
wrapText option as shown in sample below.
If you'd like to exclude pinned top/bottom rows in AG Grid from the Excel export, please set the
skipPinnedBottom properties to true.
Note the following:
- By default, all pinned rows are exported.
Skip Pinned Top Rowsis checked, the rows pinned at the top will be skipped.
Skip Pinned Bottom Rowsis checked, the rows pinned at the bottom will be skipped.
Continue to the next section: Columns.