PivotGridXlsxExportOptions Class

Contains export options specific to XLS format.

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#
VB.NET

public class PivotGridXlsxExportOptions :
    XlsxExportOptionsEx,
    IPivotGridExportOptions,
    IDataAwareExportOptions

Public Class PivotGridXlsxExportOptions
    Inherits XlsxExportOptionsEx
    Implements 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:

C#
VB.NET

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

'...
Private Sub Button_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
    Dim op As New PivotGridXlsxExportOptions()
    AddHandler op.CustomizeCell, AddressOf op_CustomizeCell
    pivorGrid1.ExportToXlsx(filePath, op)
End Sub

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