existsSheet-methods | R Documentation |
Checks the existence of a worksheet in a workbook
.
## S4 method for signature 'workbook' existsSheet(object,name)
object |
The |
name |
The sheet name to check for |
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.
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, createSheet
,
removeSheet
, renameSheet
,
getSheets
, cloneSheet
## 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") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.