PivotXlsxExportOptions Events

Contains Pivot Grid options that define how a document is exported to XLSX format in the data-aware export mode.

Name	Description
AfterAddRow	Fires immediately after a row is added to the output document.Only available in data-aware export mode. 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.
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.