XLConnect (version 0.2-9)

getReferenceCoordinates-methods: Querying the coordinates of the range reference by an Excel name

Description

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

Usage

## S3 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.

See Also

workbook, createName, existsName, removeName, getReferenceFormula

Examples

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