Learn R Programming

XLConnect (version 1.1.0)

getCellStyle-methods: Retrieving named cell styles

Description

Retrieves a named cell style from a workbook.

Usage

# S4 method for workbook
getCellStyle(object,name)

Arguments

object

The workbook to use

name

The name of the cellstyle to retrieve

Author

Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch

Details

Retrieves the cellstyle with the specified name.

See Also

workbook, cellstyle, setStyleAction, createCellStyle, getOrCreateCellStyle, existsCellStyle, setStyleNamePrefix, setCellStyle, setDataFormat, setBorder, setFillBackgroundColor, setFillForegroundColor, setFillPattern, setWrapText

Examples

Run this code
if (FALSE) {
# Load workbook (create if not existing)
wb <- loadWorkbook("getCellstyles.xlsx", create = TRUE)

# You wouldn't usually ignore the return value here...
createCellStyle(wb, 'Header')

# ... but if you did it doesn't hurt.
cs <- getCellStyle(wb, 'Header')

# Specify the cell style to use a solid foreground color
setFillPattern(cs, fill = XLC$"FILL.SOLID_FOREGROUND")

# Specify the foreground color to be used
setFillForegroundColor(cs, color = XLC$"COLOR.RED")


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

Run the code above in your browser using DataLab