getReferenceCoordinates-methods
From XLConnect v1.0.1
by Martin Studer
Querying the coordinates of the range reference by an Excel name
(DEPRECATED) Queries the coordinates of an Excel name in a '>workbook
.
Usage
# S4 method for workbook
getReferenceCoordinates(object,name)
Arguments
Note
This function is deprecated. Use getReferenceCoordinatesForName
instead.
See Also
'>workbook
, createName
, existsName
,
removeName
, getReferenceFormula
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.