Skip to main content

PivotGridXlsExportOptions Class

Contains export options specific to XLS format.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

public class PivotGridXlsExportOptions :
    XlsExportOptionsEx,
    IPivotGridExportOptions,
    IDataAwareExportOptions

Remarks

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

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

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

See Also