getReferenceFormula-methods
From XLConnect v0.2-15
by Martin Studer
Querying reference formulas of Excel names
Queries the reference formula of an Excel name in a '>workbook
.
Usage
# S4 method for workbook
getReferenceFormula(object,name)
Arguments
See Also
'>workbook
, createName
, existsName
,
removeName
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 formula for name 'mtcars'
print(getReferenceFormula(wb, name = "mtcars"))
# }
Community examples
Looks like there are no examples yet.