New to Kendo UI for jQuery? Start a free 30-day trial

Sheets.rows

configuration

The array of the sheet rows.

sheets.rows

Array

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

sheets.rows.cells

Array

The cells of each row. Each cell represents a cell from the final Excel document.

<script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [{
      rows: [
        { cells: [ { value: "Document Title" }  ] },
        { cells: [ { value: 22 }, { value: 33 }, { value: 44 }, {value: 55}  ] }
      ]
    }]
  });

  workbook.toDataURLAsync().then(function(dataURL) {
    kendo.saveAs({
      dataURI: dataURL,
      fileName: "Test.xlsx"
    });
  });
</script>

sheets.rows.height

Number

The row height (in pixels).

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [{
      rows: [{
          cells: [{ value: "this row is 100px high" }],
          height: 100
      }, {
          cells: [{ value: "this row is 200px high" }],
          height: 200
      }]
  }]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>

sheets.rows.index

Number

The zero-based index of the row in the sheet. Defaults to the index of the object in the array.

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [{
      rows: [{
          cells: [{ value: "this row is 100px high" }],
          height: 100,
          index: 1
      }]
  }]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>

sheets.rows.type

String

Used to distinguish between the various row types in the Grid. The supported values are:

"header"
"footer"
"group-header"
"group-footer"
"data"

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          rows: [
              { 
                  type: "header",
                  cells: [ { value: "Header Row" } ] 
              },
              { 
                  type: "data",
                  cells: [ { value: "Data Row 1" } ] 
              },
              { 
                  type: "data",
                  cells: [ { value: "Data Row 2" } ] 
              },
              { 
                  type: "footer",
                  cells: [ { value: "Footer Row" } ] 
              }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "row-types-example.xlsx"
  });
});
</script>