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