forEachCell

Executes a function for each cell in the range.

Parameters

callback Function

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

Example

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