PivotExportArea Enum

Lists values that specify the cell location in the exported Excel document.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v17.2.Core.dll

Declaration

C#

public enum PivotExportArea

VB.NET

Public Enum PivotExportArea

Members

Name	Description
None	A cell does not correspond to any Pivot Grid’s area.
Column	A cell corresponds to the Pivot Grid’s column area.
Row	A cell corresponds to the Pivot Grid’s row area.
Data	A cell corresponds to the Pivot Grid’s data area.

Related API Members

The following properties accept/return PivotExportArea values:

Library	Related API Members
WinForms Controls	CustomizePivotCellEventArgs.ExportArea
ASP.NET Web Forms Controls	CustomizePivotCellEventArgs.ExportArea

Remarks

Values listed by this enumerator are used to set the values of the CustomizePivotCellEventArgs.ExportArea property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PivotExportArea enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-customize-a-cell-in-the-exported-excel-document-t424327/CS/WinPivotExportCustomizeCell/Form1.cs#L45

{
    if (e.ExportArea == PivotExportArea.Data) {
        e.Formatting.BackColor = Color.Azure;

VB.NET

how-to-customize-a-cell-in-the-exported-excel-document-t424327/VB/WinPivotExportCustomizeCell/Form1.vb#L41

Private Sub exportOptions_CustomizeCell(ByVal e As CustomizePivotCellEventArgs)
    If e.ExportArea = PivotExportArea.Data Then
        e.Formatting.BackColor = Color.Azure