getReferenceCoordinatesForName-methods
From XLConnect v1.0.2
by Martin Studer
Querying the coordinates of the range reference by an Excel name
Usage
# S4 method for workbook
getReferenceCoordinatesForName(object,name)
Arguments
See Also
'>workbook
, createName
, existsName
,
removeName
, getReferenceFormula
,
getReferenceCoordinatesForTable
Examples
# NOT RUN {
# 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"))
# }
Community examples
Looks like there are no examples yet.