Expanding Cells

By default, a cell is displayed in a single row and column.

However, you can configure a cell to occupy more than one row or column.

Spanning across Columns

To expand a cell across two or more columns, set the colSpan option. As a result, all cells will follow shift to the right with the same number of columns as defined by the colSpan.

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1, B1 and C1", colSpan: 3 }, { value: "D1" }
          ]
        }
      ]
    }
  ]
});
kendo.saveAs({
    dataURI: workbook.toDataURL(),
    fileName: "Test.xlsx"
});
</script>

Spanning across Rows

To expand a cell across two or more rows, set the rowSpan option.

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1 and A2", rowSpan: 2 }, { value: "B1" }
          ]
        },
        {
          cells: [
            { value: "B2" }
          ]
        }
      ]
    }
  ]
});
kendo.saveAs({
    dataURI: workbook.toDataURL(),
    fileName: "Test.xlsx"
});
</script>

Spanning across Rows and Columns

To span a cell across two or more rows and columns simultaneously, use both the colSpan and rowSpan options.

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
    {
      rows: [
        {
          cells: [
            { value: "A1, B1, A2 and B2", rowSpan: 2, colSpan: 2 }
          ]
        }
      ]
    }
  ]
});
kendo.saveAs({
    dataURI: workbook.toDataURL(),
    fileName: "Test.xlsx"
});
</script>

See Also

In this article
Not finding the help you need? Improve this article