sheets.rows.typeString

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

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

Example

<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>
In this article
sheets.rows.type
Not finding the help you need?
Contact Support