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.
BeforeExportRow	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.