XLConnect (version 1.1.0)

existsSheet-methods: Checking for existence of worksheets in a workbook

Description

Checks the existence of a worksheet in a workbook.

Usage

# S4 method for workbook
existsSheet(object,name)

Arguments

object

The workbook to use

name

The sheet name to check for

Author

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

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.

See Also

workbook, createSheet, removeSheet, renameSheet, getSheets, cloneSheet

Examples

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