PivotXlsxExportOptions Class

Contains options that define how a Pivot Grid control is exported to XLSX format in the data-aware export mode.

Namespace : DevExpress.Web.ASPxPivotGrid

Assembly : DevExpress.Web.ASPxPivotGrid.v25.2.dll

NuGet Package : DevExpress.Web

Declaration

• C#
• VB.NET

public class PivotXlsxExportOptions :
    PivotXlsxExportOptionsBase

Public Class PivotXlsxExportOptions
    Inherits PivotXlsxExportOptionsBase

Remarks

To set custom formatting of the exported cells, you can raise the PivotXlsxExportOptions.CustomizeCell event. This event is raised before a data cell is exported to the Excel document. Use the CustomizePivotCellEventArgs.RowType and CustomizePivotCellEventArgs.ColumnType parameters to identify a row and column containing the cell. To specify the cell location in the exported Excel document, use the CustomizePivotCellEventArgs.ExportArea property. To customize the cell format, use the CustomizePivotCellEventArgs.Formatting property.

Note

Set the CustomizePivotCellEventArgs.Handled parameter to true to export cells with custom formatting.

Implements

ICloneable

DevExpress.Utils.Serializing.Helpers.IXtraSupportShouldSerialize

DevExpress.PivotGrid.Export.IPivotGridExportOptions

DevExpress.Export.IDataAwareExportOptions

Inheritance

Object ExportOptionsBase PageByPageExportOptionsBase XlExportOptionsBase XlsxExportOptions XlsxExportOptionsEx PivotXlsxExportOptionsBase PivotXlsxExportOptions

See Also

PivotXlsxExportOptions Members

DevExpress.Web.ASPxPivotGrid Namespace