XLConnect (version 1.0.1)

getReferenceFormula-methods: Querying reference formulas of Excel names

Description

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

Usage

# S4 method for workbook
getReferenceFormula(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

Examples

Run this code
# 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 formula for name 'mtcars'
print(getReferenceFormula(wb, name = "mtcars"))
# }

Run the code above in your browser using DataCamp Workspace