XLConnect (version 1.1.0)

existsCellStyle-methods: Retrieving named cell styles

Description

Checks whether a named cell style exists in a workbook.

Usage

# S4 method for workbook
existsCellStyle(object,name)

Arguments

object

The workbook to use

name

The name of the cellstyle to check

Author

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

Details

Checks whether the cellstyle with the specified name exists.

See Also

workbook, cellstyle, setCellStyle, createCellStyle, getOrCreateCellStyle

Examples

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

# Cell style 'MyStyle' does not exist yet
stopifnot(!existsCellStyle(wb, "MyStyle"))

# Create the style "MyStyle"
createCellStyle(wb, "MyStyle")

# And now it is here
stopifnot(existsCellStyle(wb, "MyStyle"))

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