getReferenceCoordinatesForName-methods {XLConnect} | R Documentation |
Queries the coordinates of an Excel name in a workbook
.
## S4 method for signature 'workbook' getReferenceCoordinatesForName(object,name)
object |
The |
name |
The name to query. This argument is vectorized such that multiple names can be queried with one method call. |
Thomas Themel
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, createName
, existsName
,
removeName
, getReferenceFormula
,
getReferenceCoordinatesForTable
# mtcars xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(demoExcelFile) # Query reference coordinate for name 'mtcars' print(getReferenceCoordinatesForName(wb, name = "mtcars"))