Back to Devexpress

PivotGridXlsxExportOptions Events

wpf-devexpress-dot-xpf-dot-pivotgrid-dot-pivotgridxlsxexportoptions-dot-underscore-events.md

latest3.9 KB
Original Source

PivotGridXlsxExportOptions Events

Contains export options specific to XLS format.

NameDescription
AfterAddRowFires immediately after a row is added to the output document.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
BeforeExportRowFires 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 XlsxExportOptionsEx.
BeforeExportTableAllows 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.
CustomizeCellAllows you to customize a PivotGrid’s cell in the exported XLSX document. Only available in data-aware export mode.
CustomizeDocumentColumnAllows 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.
CustomizeSheetFooterAllows you to customize the footer in the output document. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
CustomizeSheetHeaderAllows you to customize the header in the output document. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
CustomizeSheetSettingsAllows you to customize the output document’s settings. Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
DocumentColumnFilteringAllows you to apply filters to the exported document’s columns.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
ExportProgressFires repeatedly while the data is being exported.Only available in data-aware export mode. Inherited from XlsxExportOptionsEx.
SkipFooterRowAllows 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

PivotGridXlsxExportOptions Class

PivotGridXlsxExportOptions Members

DevExpress.Xpf.PivotGrid Namespace