PivotGridXlsxExportOptions Class

Contains export options specific to XLS format.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v21.1.dll

Declaration

public class PivotGridXlsxExportOptions :
    XlsxExportOptionsEx,
    IPivotGridExportOptions,
    IDataAwareExportOptions

Remarks

To apply export options, create the PivotGridXlsxExportOptions instance, specify the properties, and pass the PivotGridXlsxExportOptions object as a parameter to the PivotGridControl.ExportToXlsx method:

//...
void Button_Click(object sender, RoutedEventArgs e) {
    PivotGridXlsxExportOptions op = new PivotGridXlsxExportOptions();
    op.CustomizeCell += op_CustomizeCell;
    pivorGrid1.ExportToXlsx(filePath, op);
}

You can use this object’s members to specify whether to include Pivot Grid field headers in the exported document:

See Also