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.
See Also