PivotXlsExportOptions Class

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public class PivotXlsExportOptions :
    PivotXlsExportOptionsBase

VB.NET

Public Class PivotXlsExportOptions
    Inherits PivotXlsExportOptionsBase

Remarks

To set custom formatting of the exported cells, you can raise the PivotXlsExportOptions.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.

Inheritance

Object

ExportOptionsBase

PageByPageExportOptionsBase

XlExportOptionsBase

XlsExportOptions

XlsExportOptionsEx

PivotXlsExportOptionsBase

PivotXlsExportOptions