getReferenceCoordinatesForName-methods

0th

Percentile

Querying the coordinates of the range reference by an Excel name

Queries the coordinates of an Excel name in a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook
getReferenceCoordinatesForName(object,name)
Arguments
object

The '>workbook to use

name

The name to query. This argument is vectorized such that multiple names can be queried with one method call.

See Also

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

Aliases
  • getReferenceCoordinatesForName
  • getReferenceCoordinatesForName-methods
  • getReferenceCoordinatesForName,workbook-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 coordinate for name 'mtcars'
print(getReferenceCoordinatesForName(wb, name = "mtcars"))
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.