BuyLog In
DevExtreme
All docs
V 20.2
24.2
24.1
23.2
23.1
22.2
22.1
21.2
21.1
20.2
20.1
The page you are viewing does not exist in version 20.1.
19.2
The page you are viewing does not exist in version 19.2.
19.1
The page you are viewing does not exist in version 19.1.
18.2
The page you are viewing does not exist in version 18.2.
18.1
The page you are viewing does not exist in version 18.1.
17.2
The page you are viewing does not exist in version 17.2.
All docs
V20.2

General Information

.NET Subscription

What's Included
DevExpress Installation
DevExpress Code Examples

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush for Visual Studio (FREE)
TestCafe Studio

Desktop

Controls

WinForms
WPF
VCL
WinUI

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

XAF - Cross-Platform .NET App UI
XPO - .NET ORM Library (FREE)
XPO Profiler
Core Libraries
Drawing Graphics Library
.NET App Security & Web API Service (FREE)

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

Xamarin UI Controls (FREE)
.NET MAUI (FREE)

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
BI Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web
24.2
24.1
23.2
23.1
22.2
22.1
21.2
21.1
20.2
20.1
The page you are viewing does not exist in version 20.1.
19.2
The page you are viewing does not exist in version 19.2.
19.1
The page you are viewing does not exist in version 19.1.
18.2
The page you are viewing does not exist in version 18.2.
18.1
The page you are viewing does not exist in version 18.1.
17.2
The page you are viewing does not exist in version 17.2.
Full-text search
API Reference
UI Components
Data Layer
Types
animationConfig
BarGaugeBarInfo
BarGaugeLegendItem
BaseChartLegendItem
CellRange
device
DiagramAddShapeArgs
DiagramAddShapeFromToolboxArgs
DiagramBeforeChangeConnectorTextArgs
DiagramBeforeChangeShapeTextArgs
DiagramChangeConnectionArgs
DiagramChangeConnectorPointsArgs
DiagramChangeConnectorTextArgs
DiagramChangeShapeTextArgs
DiagramConnector
DiagramCustomCommand
DiagramDeleteConnectorArgs
DiagramDeleteShapeArgs
DiagramItem
DiagramMoveShapeArgs
DiagramResizeShapeArgs
DiagramShape
Event
SchedulerAppointment
SchedulerTimeZone
ExcelDataGridCell
ExcelExportDataGridProps
ExcelExportPivotGridProps
ExcelFont
ExcelPivotGridCell
area
columnIndex
columnPath
columnType
dataIndex
expanded
path
rowIndex
rowPath
rowType
text
type
value
FileSystemItem
format
FunnelLegendItem
globalConfig
PdfDataGridCell
PdfExportDataGridProps
PieChartLegendItem
positionConfig
template
UploadInfo
VectorMapLegendItem
Utilities
Angular
React
Vue
ASP.NET MVC 5
ASP.NET Core
jQuery
UI Components
Data Binding
Common Features
Migrate to the New Version

General Information

.NET Subscription

What's Included
DevExpress Installation
DevExpress Code Examples

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush for Visual Studio (FREE)
TestCafe Studio

Desktop

Controls

WinForms
WPF
VCL
WinUI

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

XAF - Cross-Platform .NET App UI
XPO - .NET ORM Library (FREE)
XPO Profiler
Core Libraries
Drawing Graphics Library
.NET App Security & Web API Service (FREE)

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

Xamarin UI Controls (FREE)
.NET MAUI (FREE)

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
BI Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web
A newer version of this page is available. Switch to the current version.

jQuery/JS Common - Object Structures - ExcelPivotGridCell

A PivotGrid cell to be exported to Excel.

Type:

Object

area

The area to which the cell belongs.

Type:

String

columnIndex

A zero-based index that indicates the position of the cell's column.

Type:

Number

columnPath

The cell's column path. Available for data area cells only.

Type:

Array<String | Number | Date>

See Also

columnType

The type of the column to which the cell belongs. Available for data area cells only.

Type:

String

Accepted Values: 'D' | 'T' | 'GT'

The columnType field has the following values:

dataIndex

The data field's index. Available for data area cells only.

Type:

Number

expanded

Indicates whether the cell is expanded. Available for row or column area cells only.

Type:

Boolean

path

The path to the row/column cell. Available for row or column area cells only.

Type:

Array<String | Number | Date>

rowIndex

A zero-based index that indicates the position of the cell's row.

Type:

Number

rowPath

The cell's row path. Available for data area cells only.

Type:

Array<String | Number | Date>

See Also

rowType

The type of the row to which the cell belongs. Available for data area cells only.

Type:

String

Accepted Values: 'D' | 'T' | 'GT'

The rowType field has the following values:

text

The text displayed in the cell.

Type:

String

type

The cell's type. Available for row or column area cells only.

Type:

String

Accepted Values: 'D' | 'T' | 'GT'

The type field has the following values.

value

The cell's value.