setBorder-methods

Specifying borders for cell styles

Specifies borders for a '>cellstyle.

Usage

# S4 method for cellstyle
setBorder(object,side,type,color)

Details

Specifies the border for a '>cellstyle. Note that the arguments type and color should be of the same length as side. In other words, for each specified side there should be a corresponding specification of type and color. If this is not the case the arguments will be automatically replicated to the length of side.

See Also

'>workbook, '>cellstyle, setCellStyle, setStyleAction, XLC

Aliases

• setBorder
• setBorder-methods
• setBorder,cellstyle-method

Examples

# NOT RUN {
# Load workbook (create if not existing)
wb <- loadWorkbook("setBorder.xlsx", create = TRUE)

# Create a worksheet
createSheet(wb, name = "cellstyles")

# Create a custom anonymous cell style
cs <- createCellStyle(wb)

# Specify the border for the cell style created above
setBorder(cs, side = c("bottom", "right"), type = XLC$"BORDER.THICK", 
          color = c(XLC$"COLOR.BLACK", XLC$"COLOR.RED"))

# Set the cell style created above for the top left cell (A1) in the 
# 'cellstyles' worksheet
setCellStyle(wb, sheet = "cellstyles", row = 1, col = 1, cellstyle = cs)

# Save the workbook
saveWorkbook(wb)

# clean up 
file.remove("setBorder.xlsx")
# }