sheets.rows.cells Array
The cells of each row. Each cell represents a cell from the final Excel document.
Example - specify the cells of each row
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [{
rows: [
{ cells: [ { value: "Document Title" } ] },
{ cells: [ { value: 22 }, { value: 33 }, { value: 44 }, {value: 55} ] }
]
}]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "Test.xlsx"
});
});
</script>
Related Properties
- sheets.rows.cells.background
- sheets.rows.cells.borderRight
- sheets.rows.cells.borderRight.color
- sheets.rows.cells.borderRight.size
- sheets.rows.cells.bold
- sheets.rows.cells.borderTop
- sheets.rows.cells.borderTop.color
- sheets.rows.cells.borderTop.size
- sheets.rows.cells.color
- sheets.rows.cells.borderLeft
- sheets.rows.cells.borderLeft.color
- sheets.rows.cells.borderLeft.size
- sheets.rows.cells.colSpan
- sheets.rows.cells.borderBottom
- sheets.rows.cells.borderBottom.color
- sheets.rows.cells.borderBottom.size
- sheets.rows.cells.fontFamily
- sheets.rows.cells.fontName
- sheets.rows.cells.fontSize
- sheets.rows.cells.format
- sheets.rows.cells.formula
- sheets.rows.cells.hAlign
- sheets.rows.cells.index
- sheets.rows.cells.italic
- sheets.rows.cells.rowSpan
- sheets.rows.cells.textAlign
- sheets.rows.cells.underline
- sheets.rows.cells.wrap
- sheets.rows.cells.vAlign
- sheets.rows.cells.verticalAlign
- sheets.rows.cells.value