sheets.rows.cells.borderBottom Object

The style information for the bottom border of the cell.

sheets.rows.cells.borderBottom.color String

The color of the bottom border of the cell. While many standard CSS formats are supported, the canonical form is #ccff00.

sheets.rows.cells.borderBottom.size Number

The width (in pixels) of the border.

The allowed values are:

  • 1 - Results in a "thin" border.
  • 2 - Results in a "medium" border.
  • 3 - Results in a "thick" border.

Example - adding a bottom border to the cell

<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
 {
     rows: [
       { cells: [ { value: "Border", borderBottom: { color: "#ff0000", size: 3 } } ] }
     ]
 }
]
});
kendo.saveAs({
dataURI: workbook.toDataURL(),
fileName: "Test.xlsx"
});
</script>
In this article