sheets.rows.cells.index Object

The zero-based index of the cell in the row. Records missing an index will be placed in the first available cell on the row.

Important Mixing indexed with non-indexed cells might yield invalid results. If you want to use both, place the indexed cells at the end of the array.

Example - list cells by index

  var workbook = new kendo.ooxml.Workbook({
    sheets: [{
      rows: [{
          cells: [
              { value: "B1", index: 1 },
              { value: "E1", index: 4 }
    dataURI: workbook.toDataURL(),
    fileName: "Test.xlsx"
In this article
Not finding the help you need? Improve this article