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.

For more information on the formats that Excel supports, refer to the page on creating a custom number format.

Example - setting the cell format

var workbook = new kendo.ooxml.Workbook({
  sheets: [
          rows: [
            { cells: [ { value: new Date(), format: "yy-MM-dd" } ] }
  dataURI: workbook.toDataURL(),
  fileName: "Test.xlsx"
In this article