All docs
V21.1
21.2
21.1
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

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.

Type: any