sheets.rows.cells.verticalAlign String (default: "bottom")

Sets the vertical alignment of the cell content.

The supported values are:

  • "top"
  • "center"
  • "bottom"

Example - setting the horizontal alignment

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          columns: [ { width: 200 } ],
          rows: [
            { cells: [
              { rowSpan: 2, value: "Top", verticalAlign: "top" },
              { rowSpan: 2, value: "Middle", verticalAlign: "center" },
              { rowSpan: 2, value: "Bottom", verticalAlign: "bottom" }
             ]
            }
          ]
      }
  ]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>
In this article