Edit this page

cellInfo

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

Parameters

columnIndex Number

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

rowIndex Number

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

Returns

Object the data cell information.

The fields of the result object:

  • columnTuple - the tuple of the corresponding column header cell
  • rowTuple - the tuple of the corresponding row header cell
  • measure - the measure value of the data cell
  • dataItem - the data item itself

Example - get an information for a specific data cell

<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/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

        console.log(info);
    });
});
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy