PivotGridXlsxExportOptions Events
Contains export options specific to XLS format.| Name | Description |
|---|---|
| AfterAddRow | Fires immediately after a row is added to the output document.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| BeforeExportRow | Fires consecutively for each control row when this row is about to be exported. Allows you to skip specific rows if they do not meet your custom criteria. Inherited from XlsxExportOptionsEx. |
| BeforeExportTable | Allows you to customize a native Excel table’s settings before export. This event is in effect when the XlsxExportOptionsEx.LayoutMode property is set to Table. Inherited from XlsxExportOptionsEx. |
| CustomizeCell | Allows you to customize a PivotGrid’s cell in the exported XLSX document. Only available in data-aware export mode. |
| CustomizeDocumentColumn | Allows you to customize an individual column in the exported document - change its width, formatting, collapse the group containing the column or hide the column.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| CustomizeSheetFooter | Allows you to customize the footer in the output document. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| CustomizeSheetHeader | Allows you to customize the header in the output document. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| CustomizeSheetSettings | Allows you to customize the output document’s settings. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| DocumentColumnFiltering | Allows you to apply filters to the exported document’s columns.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| ExportProgress | Fires repeatedly while the data is being exported.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
| SkipFooterRow | Allows you to hide certain summary footers (or certain multi-line summary footers’ lines) from the exported document.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx. |
See Also