sheetsArray
The sheets of the workbook. Every sheet represents a page from the final Excel file.
Example
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
name: "Products",
rows: [
{ cells: [ { value: "Product" }, { value: "Price" } ] },
{ cells: [ { value: "Laptop" }, { value: 999.99 } ] },
{ cells: [ { value: "Phone" }, { value: 599.99 } ] }
]
},
{
name: "Summary",
rows: [
{ cells: [ { value: "Total Items" }, { value: 2 } ] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "multiple-sheets.xlsx"
});
});
</script>
In this article