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").kendoPivotGrid({
        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: {
                    url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                    dataType: "text",
                    contentType: "text/xml",
                    type: "POST"
                }
            },
            schema: {
                type: "xmla"
            }
        }
    }).data("kendoPivotGrid");

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

        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>