Edit this page

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

Sets the vertical alignment of the cell value. Supported values are "top", "center" and "bottom".

Example - set 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" }
             ]
            }
          ]
      }
  ]
});
kendo.saveAs({
  dataURI: workbook.toDataURL(),
  fileName: "Test.xlsx"
});
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy