getForceFormulaRecalculation-methods
From XLConnect v1.0.2
by Martin Studer
Querying the coordinates of the range reference by an Excel name
Queries the "force formula recalculation" flag on an Excel worksheet.
Usage
# S4 method for workbook,character
getForceFormulaRecalculation(object,sheet)
# S4 method for workbook,numeric
getForceFormulaRecalculation(object,sheet)
Arguments
- object
- sheet
The name or index of the sheet to query. This argument is vectorized such that multiple sheets can be queried with one method call. If
sheet = "*"
, the flag is queried for all sheets in the'>workbook
(in the order as returned bygetSheets
).
See Also
'>workbook
, getSheets
,
setForceFormulaRecalculation
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)
# Ask whether Excel will automatically recalculate formulas on sheet mtcars
print(getForceFormulaRecalculation(wb, sheet = "mtcars"))
# }
Community examples
Looks like there are no examples yet.