New to Kendo UI for jQuery? Start a free 30-day trial

CellInfo

methods

Returns an information about a data cell at a specific column and row index.

cellInfo

Parameters:columnIndexNumber

The index of the column cell that crosses the data cell.

rowIndexNumber

The index of the row cell that crosses the data cell.

Returns:Object

the data cell information.

<button id="get">Get info</button>
<div id="pivotgrid"></div>
<script>
$(function() {
    var pivotgrid = $("#pivotgrid").kendoPivotGridV2({
        height: 550,
        dataSource: {
            type: "xmla",
            columns: [{ name: "[Date].[Calendar]", expand: true } ],
            rows: [{ name: "[Product].[Category]", expand: true }],
            measures: ["[Measures].[Internet Sales Amount]"],
            transport: {
                connection: {
                    catalog: "Adventure Works DW 2008R2",
                    cube: "Adventure Works"
                },
                read: 'https://demos.telerik.com/service/v2/olap/msmdpump.dll'
            }
        }
    }).data("kendoPivotGridV2");

    $("#button").click(function() {
        var columnIndex = 1;
        var rowIndex = 1;

        var info = pivotgrid.cellInfo(columnIndex, rowIndex); //retrieve data cell information

/* The result can be observed in the DevTools(F12) console of the browser. */
        console.log(info);
    });
});
</script>