Checking for existence of worksheets in a workbook

Checks the existence of a worksheet in a workbook.

# S4 method for class 'workbook'
existsSheet(object,name)

Arguments

object

The workbook to use

name

The sheet name to check for

Details

Checks if the specified worksheet exists. Returns TRUE if it exists, otherwise FALSE. The name argument is vectorized which allows to check for existence of multiple worksheets with one call.

Author

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

See also

workbook, createSheet, removeSheet, renameSheet, getSheets, cloneSheet

Examples

if (FALSE) { # \dontrun{
# mtcars xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(demoExcelFile)

# Check for existence of a worksheet called 'mtcars'
existsSheet(wb, "mtcars")
} # }