getReferenceCoordinatesForTable-methods

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)

See Also

'>workbook, createName, existsName, removeName, getReferenceFormula, getReferenceCoordinatesForName

Aliases

• getReferenceCoordinatesForTable
• getReferenceCoordinatesForTable-methods
• getReferenceCoordinatesForTable,workbook,numeric-method
• getReferenceCoordinatesForTable,workbook,character-method

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"))
# }