sheets.rows.cells.borderRightObject

The style information for the right border of the cell.

Example

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          rows: [
              { cells: [ 
                  { value: "Right border", borderRight: { color: "#009900", size: 3 } },
                  { value: "Next cell" }
              ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "border-right-example.xlsx"
  });
});
</script>

sheets.rows.cells.borderRight.colorString

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

Example

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          rows: [
              { cells: [ 
                  { value: "Crimson", borderRight: { color: "#dc143c", size: 2 } },
                  { value: "Gold", borderRight: { color: "#ffd700", size: 2 } },
                  { value: "Silver", borderRight: { color: "#c0c0c0", size: 2 } }
              ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "right-border-colors-example.xlsx"
  });
});
</script>

sheets.rows.cells.borderRight.sizeNumber

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 right border to the cell

<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
 {
     rows: [
       { cells: [ { value: "Border", borderRight: { color: "#ff0000", size: 3 } } ] }
     ]
 }
]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>