Learn R Programming

XLConnect (version 1.1.0)

getOrCreateCellStyle-methods: Retrieving or creating named cell styles

Description

Retrieves or creates cell styles in workbooks.

Usage

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

Arguments

object

The workbook to use

name

The name of the cellstyle to retrieve or to create

Author

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

Details

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

See Also

workbook, cellstyle, setCellStyle, createCellStyle, existsCellStyle

Examples

Run this code
if (FALSE) {
# 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")
}

Run the code above in your browser using DataLab