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>In this article