getOrCreateCellStyle-methods {XLConnect}

Retrieving or creating named cell styles

Description

Retrieves or creates cell styles in workbooks.

Usage

## S4 method for signature 'workbook,character'
getOrCreateCellStyle(object,name)

Arguments

object

The workbook to use

name

The name of the cellstyle to retrieve or to create

Details

Retrieves an existing cellstyle if it exists or creates a new one if it does not exist yet.

Author(s)

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See Also

workbook, cellstyle, setCellStyle, createCellStyle, existsCellStyle

Examples

## Not run: 
# Load workbook (create if not existing)
wb <- loadWorkbook("getOrCreateCellStyle.xlsx", create = TRUE)

# The first time, the style does not exist yet and gets created
myStyle <- getOrCreateCellStyle(wb, name = "MyStyle")

# The second time, we retrieve the already existing style 
myStyle <- getOrCreateCellStyle(wb, name = "MyStyle")

# clean up 
file.remove("getOrCreateCellStyle.xlsx")

## End(Not run)