getReferenceFormula-methods: Querying reference formulas of Excel names

Description Usage Arguments Author(s) See Also Examples

Description

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

Usage

1
2
## S4 method for signature '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.

Author(s)

Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com

See Also

workbook, createName, existsName, removeName

Examples

1
2
3
4
5
6
7
8
# 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"))

XLConnect documentation built on May 29, 2017, 7:04 p.m.

Search within the XLConnect package
Search all R packages, documentation and source code