sheets.rows Array

The array of the sheet rows.

Example - specifying the rows of the sheet

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          rows: [
            { cells: [ { value: "John" }, { value: "Doe" } ] },
            { cells: [ { value: "Jane" }, { value: "Doe" } ] }
          ]
      }
  ]
});
kendo.saveAs({
  dataURI: workbook.toDataURL(),
  fileName: "Test.xlsx"
});
</script>

Related Properties

• sheets.rows.cells
• sheets.rows.cells.background
• sheets.rows.cells.borderRight
• sheets.rows.cells.borderRight.color
• sheets.rows.cells.borderRight.size
• sheets.rows.cells.bold
• sheets.rows.cells.borderTop
• sheets.rows.cells.borderTop.color
• sheets.rows.cells.borderTop.size
• sheets.rows.cells.color
• sheets.rows.cells.borderLeft
• sheets.rows.cells.borderLeft.color
• sheets.rows.cells.borderLeft.size
• sheets.rows.cells.colSpan
• sheets.rows.cells.borderBottom
• sheets.rows.cells.borderBottom.color
• sheets.rows.cells.borderBottom.size
• sheets.rows.cells.fontFamily
• sheets.rows.cells.fontName
• sheets.rows.cells.fontSize
• sheets.rows.cells.format
• sheets.rows.cells.formula
• sheets.rows.cells.hAlign
• sheets.rows.cells.index
• sheets.rows.cells.italic
• sheets.rows.cells.rowSpan
• sheets.rows.cells.textAlign
• sheets.rows.cells.underline
• sheets.rows.cells.wrap
• sheets.rows.cells.vAlign
• sheets.rows.cells.verticalAlign
• sheets.rows.cells.value
• sheets.rows.index
• sheets.rows.height
• sheets.rows.type