sheets.rows.cells.colSpan Number
(default: 1)
Sets the number of columns that a cell occupies.
Example - making a cell span over two columns
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
columns: [ { width: 100}, { width: 100 } ],
rows: [
{ cells: [ { value: "Occupies two columns", colSpan: 2 } ] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "Test.xlsx"
});
});
</script>