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 } ] }
          ]
      }
  ]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>