Queries the "force formula recalculation" flag on an Excel worksheet.
## S4 method for signature 'workbook,character' getForceFormulaRecalculation(object,sheet) ## S4 method for signature 'workbook,numeric' getForceFormulaRecalculation(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
Mirai Solutions GmbH https://mirai-solutions.ch
## 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")) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.