getDefinedNames-methods {XLConnect} | R Documentation |
Retrieves the defined names in a workbook
.
## S4 method for signature 'workbook' getDefinedNames(object, validOnly)
object |
The |
validOnly |
If |
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, createName
, removeName
,
existsName
, readNamedRegion
,
writeNamedRegion
# mtcars xlsx file from demoFiles subfolder of package XLConnect mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(mtcarsFile) # Retrieve defined names with valid references getDefinedNames(wb)