getForceFormulaRecalculation-methods | R Documentation |
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)
object |
The |
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 |
Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, getSheets
,
setForceFormulaRecalculation
## 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.