Edit this page

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

  <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>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy