getReferenceFormula-methods {XLConnect} | R Documentation |
Queries the reference formula of an Excel name in a workbook
.
## S4 method for signature 'workbook' getReferenceFormula(object,name)
object |
The |
name |
The name to query. This argument is vectorized such that multiple names can be queried with one method call. |
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, createName
, existsName
,
removeName
# 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"))