existsName-methods {XLConnect} | R Documentation |
Checking existence of names in a workbook
Description
Checks the existence of a name in a workbook
.
Usage
## S4 method for signature 'workbook'
existsName(object, name)
Arguments
object |
The |
name |
The name to check for |
Details
Returns TRUE
if the specified name
exists and FALSE
otherwise. Note that the name
argument is vectorized and
therefore multiple names can be checked for existence in one method call.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
, createName
, removeName
,
getDefinedNames
, readNamedRegion
,
writeNamedRegion
Examples
## Not run:
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")
# Load workbook
wb <- loadWorkbook(mtcarsFile)
# Check if the name 'mtcars' exists
# (should return TRUE since the name is defined as 'mtcars!$A$1:$K$33')
existsName(wb, name = "mtcars")
## End(Not run)
[Package XLConnect version 1.0.10 Index]