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

Accepted Values: 'column' | 'row' | 'data'

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

headerType

The header type. Available if the cell belongs to the field panel.

Type:

String

Accepted Values: 'column' | 'row' | 'data' | 'filter'

This property is available only when at least one of the following properties is enabled:

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