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>