PivotXlsExportOptions Events

Contains options that define how a Pivot Grid control is exported to XLS 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 XlsExportOptionsEx.
BeforeExportTable Allows you to customize a native Excel table’s settings before export. This event is in effect when the XlsExportOptionsEx.LayoutMode property is set to Table.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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. Inherited from XlsExportOptionsEx.
CustomizeSheetFooter Allows you to add a footer to the output document. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
CustomizeSheetHeader Allows you to add a header to the output document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
CustomizeSheetSettings Allows you to customize the output document’s settings. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
DocumentColumnFiltering Allows you to apply filters to the exported document’s columns.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ExportProgress Fires repeatedly while the data is being exported.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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 XlsExportOptionsEx.
See Also