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

ForEachCell

methods

Executes a function for each cell in the range.

forEachCell

Parameters:callbackFunction

The function that will be executed against every cell. The function receives the following parameters:

rowIndex - the row index of the cell
columnIndex - the column index of the cell
cellProperties - the cell properties

<div id="spreadsheet"></div>
<script>

    $("#spreadsheet").kendoSpreadsheet({
        sheets: [
            { rows: [
                { cells: [
                    { value: "A1" }, { value: "B1" }
                ] },
                { cells: [
                    { value: "A2" }, { value: "B2" }
                ] }
            ] }
        ]
    });


    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();
    var range = sheet.range("A1:B2");

    range.forEachCell(function (row, column, cellProperties) {
	/* The result can be observed in the DevTools(F12) console of the browser. */
        console.log(row, column, cellProperties);
    });
</script>