XLConnect (version 0.2-15)

setForceFormulaRecalculation-methods: Forcing Excel to recalculate formula values when opening a workbook

Description

This function controls a flag that forces Excel to recalculate formula values when a workbook is opened.

Usage

# S4 method for workbook,character
setForceFormulaRecalculation(object,sheet,value)
# S4 method for workbook,numeric
setForceFormulaRecalculation(object,sheet,value)

Arguments

object

The '>workbook to use

sheet

The name or index of the sheet for which to force formula recalculation. If sheet = "*", the flag is set for all sheets in the '>workbook.

value

logical specifying if formula recalculation should be forced or not

Details

The arguments sheet and value are vectorized such that multiple worksheets can be controlled with one method call.

See Also

'>workbook, getForceFormulaRecalculation

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)

# Tell Excel to automatically recalculate formulas on sheet mtcars
setForceFormulaRecalculation(wb, sheet = "mtcars", TRUE)
# The same with a numerical sheet index
setForceFormulaRecalculation(wb, sheet = 1, TRUE)
# }

Run the code above in your browser using DataCamp Workspace