Querying the coordinates of the range reference by an Excel name — getReferenceCoordinates-methods • XLConnect

(DEPRECATED) Queries the coordinates of an Excel named range in a workbook.

# S4 method for class 'workbook'
getReferenceCoordinates(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.

Note

This function is deprecated. Use getReferenceCoordinatesForName instead.

Author

Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch

See also

workbook, createName, existsName, removeName, getReferenceFormula

Examples

if (FALSE) { # \dontrun{
# 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"))
} # }