PivotGridXlsExportOptions Class

Contains export options specific to XLS format.

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#
VB.NET

public class PivotGridXlsExportOptions :
    XlsExportOptionsEx,
    IPivotGridExportOptions,
    IDataAwareExportOptions

Public Class PivotGridXlsExportOptions
    Inherits XlsExportOptionsEx
    Implements 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:

C#
VB.NET

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

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

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