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

Sheets.rows

configuration

The row data for this sheet.

sheets.rows

Array

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{
      rows: [
        {
          height: 25,
          cells: [
            { value: "Name", bold: true },
            { value: "Age", bold: true }
          ]
        },
        {
          cells: [
            { value: "John" },
            { value: 30 }
          ]
        }
      ]
    }]
  });
</script>

sheets.rows.cells

Array

The cells for this row.

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{
      rows: [{
        cells: [
          { value: "Product", fontFamily: "Arial", fontSize: "14px" },
          { value: "Price", textAlign: "center" },
          { value: "Quantity", color: "#ff0000" }
        ]
      }]
    }]
  });
</script>

sheets.rows.height

Number

The row height in pixels. Defaults to rowHeight.

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        rows: [{
            height: 80,
            cells: [{
                value: "Tall row"
            }]
        }, {
            height: 30,
            cells: [{
                value: "Short row"
            }]
        }]
    }]
});
</script>

sheets.rows.index

Number

The absolute row index. Required to ensure correct positioning.

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        rows: [{
            index: 0,
            cells: [{
                value: "Row 1"
            }]
        }, {
            index: 3,
            cells: [{
                value: "Row 4 (skipping rows 2 and 3)"
            }]
        }]
    }]
});
</script>

sheets.rows.type

String

The table row element role in the context of the Grid table structure.

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        rows: [{
            type: "data",
            cells: [{
                value: "Data row"
            }]
        }, {
            type: "header",
            cells: [{
                value: "Header row"
            }]
        }]
    }]
});
</script>