getReferenceCoordinatesForTable-methods | R Documentation |
Queries the coordinates of an Excel table (Office 2007+) in a workbook
.
## S4 method for signature 'workbook,numeric' getReferenceCoordinatesForTable(object,sheet,table) ## S4 method for signature 'workbook,character' getReferenceCoordinatesForTable(object,sheet,table)
object |
The |
sheet |
The index or name of the worksheet on which to look for the specified |
table |
The name of the table to query. This argument is vectorized such that multiple tables can be queried with one method call. |
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, createName
, existsName
,
removeName
, getReferenceFormula
,
getReferenceCoordinatesForName
## 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")) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.