existsName-methods {XLConnect} | R Documentation |
Checks the existence of a name in a workbook
.
## S4 method for signature 'workbook' existsName(object, name)
object |
The |
name |
The name to check for |
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.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, createName
, removeName
,
getDefinedNames
, readNamedRegion
,
writeNamedRegion
# 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")