Last chance! 50% off unlimited learning
Sale ends in
Sets a color on a specified worksheet tab. This only works for xlsx files.
# S4 method for workbook,character
setSheetColor(object,sheet,color)
# S4 method for workbook,numeric
setSheetColor(object,sheet,color)
The workbook to use
The name or index of the sheet on which to set the tab color
The color to use for the sheet tab. The color is normally specified
via a corresponding color constant from the XLC object.
Nicola Lambiase
Mirai Solutions GmbH https://mirai-solutions.ch
workbook, XLC
if (FALSE) {
# Load workbook (create if not existing)
wb <- loadWorkbook("sheetcolor.xlsx", create = TRUE)
# Create a worksheet named 'Sheet1'
createSheet(wb, name = "Sheet1")
# Set the "Sheet1" tab color as red
setSheetColor(wb, "Sheet1", XLC$COLOR.RED)
# Create a worksheet named 'Sheet2'
createSheet(wb, name = "Sheet2")
# Set the tab color of the second workbook sheet as green
setSheetColor(wb, 2, XLC$COLOR.GREEN)
# Save workbook (this actually writes the file to disk)
saveWorkbook(wb)
# clean up
file.remove("sheetcolor.xlsx")
}
Run the code above in your browser using DataLab