sheets.rows.cells.borderBottomObject
The style information for the bottom border of the cell.
Example
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
rows: [
{ cells: [
{ value: "Cell with bottom border", borderBottom: { color: "#0066cc", size: 2 } }
] },
{ cells: [
{ value: "Regular cell below" }
] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "border-bottom-example.xlsx"
});
});
</script>sheets.rows.cells.borderBottom.colorString
The color of the bottom 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: "Red border", borderBottom: { color: "#ff0000", size: 1 } },
{ value: "Green border", borderBottom: { color: "#00ff00", size: 1 } },
{ value: "Blue border", borderBottom: { color: "#0000ff", size: 1 } }
] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "border-colors-example.xlsx"
});
});
</script>sheets.rows.cells.borderBottom.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 bottom border to the cell
<script>
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
rows: [
{ cells: [ { value: "Border", borderBottom: { color: "#ff0000", size: 3 } } ] }
]
}
]
});
workbook.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: "Test.xlsx"
});
});
</script>In this article