Function adds a style to a specified set of cells.
addStyle(wb, sheet, style, rows, cols, gridExpand = FALSE, stack = FALSE)
A Workbook object containing a worksheet.
A worksheet to apply the style to.
A style object returned from createStyle()
Rows to apply style to.
columns to apply style to.
If TRUE
, style will be applied to all combinations of rows and cols.
If TRUE
the new style is merged with any existing cell styles. If FALSE, any
existing style is replaced by the new style.
expand.grid
## See package vignette for more examples.
## Create a new workbook
wb <- createWorkbook("My name here")
## Add a worksheets
addWorksheet(wb, "Expenditure", gridLines = FALSE)
## write data to worksheet 1
writeData(wb, sheet = 1, USPersonalExpenditure, rowNames = TRUE)
## create and add a style to the column headers
headerStyle <- createStyle(
fontSize = 14, fontColour = "#FFFFFF", halign = "center",
fgFill = "#4F81BD", border = "TopBottom", borderColour = "#4F81BD"
)
## style for body
bodyStyle <- createStyle(border = "TopBottom", borderColour = "#4F81BD")
addStyle(wb, sheet = 1, bodyStyle, rows = 2:6, cols = 1:6, gridExpand = TRUE)
setColWidths(wb, 1, cols = 1, widths = 21) ## set column width for row names column
if (FALSE) { # \dontrun{
saveWorkbook(wb, "addStyleExample.xlsx", overwrite = TRUE)
} # }