sheets.rows.cells.formula String
Sets the formula that Excel uses to compute and display the cell content.
Example - setting the cell formula
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
rows: [
{ cells: [ { value: 1 }, { formula: "=SUM(A:A)" } ] },
{ cells: [ { value: 2 } ] }
]
}
]
});
kendo.saveAs({
dataURI: workbook.toDataURL(),
fileName: "Test.xlsx"
});
</script>