sheets.rows.cells.index Object
The zero-based index of the cell in the row. Records which miss an index will be placed in the first available cell on the row.
Mixing indexed with non-indexed cells might cause invalid results. To use both, place the indexed cells at the end of the array.
Example - listing cells by index
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [{
rows: [{
cells: [
{ value: "B1", index: 1 },
{ value: "E1", index: 4 }
]
}]
}]
});
kendo.saveAs({
dataURI: workbook.toDataURL(),
fileName: "Test.xlsx"
});
</script>