XLConnect (version 1.0.1)

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

Details

Checks whether the '>cellstyle with the specified name exists.

See Also

'>workbook, '>cellstyle, setCellStyle, createCellStyle, getOrCreateCellStyle

Examples

Run this code
# NOT RUN {
# 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")
# }

Run the code above in your browser using DataCamp Workspace