Edit this page

sheets.rows.cells.format String

Sets the format that Excel uses to display the cell value.

The format option does not follow the {0:} syntax that kendo.format uses.

The Create a custom number format page describes the formats that Excel supports.

Example - set the cell format

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          rows: [
            { cells: [ { value: new Date(), format: "yy-MM-dd" } ] }
          ]
      }
  ]
});
kendo.saveAs({
  dataURI: workbook.toDataURL(),
  fileName: "Test.xlsx"
});
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy