PivotXlsxExportOptions Events

Contains options that define how a Pivot Grid control 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 specify cell formatting when exporting a Pivot Grid control to XLSX format in data-aware 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