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.