A cellData object contains all the information about the cell.

Properties

NameTypeDescription

columnIndex

Number
An index of the cell’s column.
columnArray of Hierarchy ObjectsContains the hierarchies from the column associated with the cell.
height  Number Defines a height of the cell.
hierarchy  Object Defines a hierarchy associated with the cell.
isClassicTotalRow Boolean Specifies whether the cell contains a subtotal value and is formatted according to the classic form.
isDrillThrough
Boolean
Specifies whether the cell belongs to the drill-through view (true) or the grid (false).
isGrandTotal
Boolean
Specifies whether the cell contains a grand total value.

isGrandTotalColumn

Boolean
Specifies whether the cell contains a grand total value of the column.

isGrandTotalRow

Boolean

Specifies whether the cell contains a grand total value of the row.

isTotal

Boolean
Specifies whether the cell contains a total value.

isTotalColumn

Boolean
Specifies whether the cell contains a total value of the column.

isTotalRow

Boolean

Specifies whether the cell contains a total value of the row.

label
String Contains a label of the cell.
levelNumberDefines a level of the hierarchy.

measure
ObjectDefines a measure associated with the cell.
member Object Defines a member associated with the cell.

rowIndex
Number An index of the cell’s row.
rowsArray of Hierarchy Objects Contains the hierarchies from the
row associated with the cell.
type String Defines a type of the cell. Possible values:
"header" and "value".
valueNumber Contains a value of the cell.
width Number Defines a width of the cell.
xNumber Defines an absolute X-positioning of the cell on the page
yNumberDefines an absolute Y-positioning of the cell on the page