getCellStyle-methods

0th

Percentile

Retrieving named cell styles

Retrieves a named cell style from a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook
getCellStyle(object,name)
Arguments
object

The '>workbook to use

name

The name of the '>cellstyle to retrieve

Details

Retrieves the '>cellstyle with the specified name.

See Also

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

Aliases
  • getCellStyle
  • getCellStyle-methods
  • getCellStyle,workbook-method
Examples
# NOT RUN {
# 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")

# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.