getReferenceCoordinatesForTable-methods
From XLConnect v1.0.1
by Martin Studer
Querying the coordinates of the range of an Excel table
Queries the coordinates of an Excel table (Office 2007+) in a '>workbook
.
Usage
# S4 method for workbook,numeric
getReferenceCoordinatesForTable(object,sheet,table)
# S4 method for workbook,character
getReferenceCoordinatesForTable(object,sheet,table)
Arguments
See Also
'>workbook
, createName
, existsName
,
removeName
, getReferenceFormula
,
getReferenceCoordinatesForName
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 coordinates for table 'MtcarsTable' on sheet
# 'mtcars_table'
print(getReferenceCoordinatesForTable(wb, sheet = "mtcars_table",
table = "MtcarsTable"))
# }
Community examples
Looks like there are no examples yet.