This function controls a flag that forces Excel to recalculate formula values when a workbook is opened.
1 2 3 4
The name or index of the sheet for which to force formula recalculation.
value are vectorized such
that multiple worksheets can be controlled with one method call.
A typical use for this flag is forcing Excel into updating formulas
that reference cells affected by
The exact behavior of Excel when the flag is set depends on version and file format.
Mirai Solutions GmbH http://www.mirai-solutions.com
1 2 3 4 5 6 7 8 9 10
# 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)
Loading required package: XLConnectJars OpenJDK 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed XLConnect 0.2-12 by Mirai Solutions GmbH [aut], Martin Studer [cre], The Apache Software Foundation [ctb, cph] (Apache POI, Apache Commons Codec), Stephen Colebourne [ctb, cph] (Joda-Time Java library), Graph Builder [ctb, cph] (Curvesapi Java library) http://www.mirai-solutions.com , http://miraisolutions.wordpress.com ZoneInfo: /usr/share/javazi/ZoneInfoMappings (Permission denied) Warning message: system call failed: Cannot allocate memory
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.