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 | Fires consecutively for each control row when this row is about to be exported. Allows you to skip specific rows if they do not meet your custom criteria. 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