getReferenceCoordinates-methods

Querying the coordinates of the range reference by an Excel name

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

Usage

# S4 method for workbook
getReferenceCoordinates(object,name)

Note

This function is deprecated. Use getReferenceCoordinatesForName instead.

See Also

'>workbook, createName, existsName, removeName, getReferenceFormula

Aliases

• getReferenceCoordinates
• getReferenceCoordinates-methods
• getReferenceCoordinates,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"))
# }