getReferenceCoordinatesForTable-methods

0th

Percentile

Querying the coordinates of the range of an Excel table

Queries the coordinates of an Excel table (Office 2007+) in a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook,numeric
getReferenceCoordinatesForTable(object,sheet,table)
# S4 method for workbook,character
getReferenceCoordinatesForTable(object,sheet,table)
Arguments
object

The '>workbook to use

sheet

The index or name of the worksheet on which to look for the specified table

table

The name of the table to query. This argument is vectorized such that multiple tables can be queried with one method call.

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"))
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.