API calls for the pivot table

Learn more about available API calls for the pivot table control.

getCell

getCell(rowIdx: Number, colIdx: Number): GridCellObject

Gets the cell object at the specified row and column coordinates.

Parameter/Type	Description
rowIdxNumber	The index of the row.
colIdxNumber	The index of the column.

Example

pivotTable.getCell(1, 2);

Returns: GridCellObject, which contains information about the cell.

getSelectedCells(): GridCellObject[]

Gets all currently selected cells.

Example:

pivotTable.getSelectedCells();

Returns: GridCellObject[]

scrollToColumn(columnIndex: Number)

Scrolls the grid to the specified column.

Parameter/Type	Description
columnIndexNumber	The index of the column to which the grid will be scrolled. Indexes start from `0`.

Example:

pivotTable.scrollToColumn(5);

scrollToRow(rowIndex: Number)

Scrolls the grid to the specified row.

Parameter/Type	Description
rowIndexNumber	The index of the row to which the grid will be scrolled. Indexes start from `0`.

Example:

pivotTable.scrollToRow(5);