XLConnect (version 1.0.3)

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

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

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

Run the code above in your browser using DataCamp Workspace