autoRefresh: Force Refresh Pivot Tables and Formulae

Description Usage Arguments Details Value Author(s) Examples

Description

Functions to force formula calculation or refresh of pivot tables when the Excel file is opened.

Usage

1
2
3

Arguments

file

the path of the source file where formulae/pivot table needs to be refreshed

output

the path of the output file. If it is NULL then the source file will be overwritten.

verbose

a boolean. Set to TRUE if you want details.

Details

forcePivotTableRefresh forces pivot tables to be refreshed when the Excel file is opened.

forceFormulaRefresh forces formulae to be recalculated when the Excel file is opened.

Value

forcePivotTableRefresh does not return any results

forceFormulaRefresh does not return any results

Author(s)

Tom Kwong

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
## Not run: 
# Patch a file where its pivot tables are not recalculated when the file is opened
forcePivotTableRefresh("/tmp/file.xlsx")
forcePivotTableRefresh("/tmp/file.xlsx", "/tmp/fixed_file.xlsx")

# Patch a file where its formulae are not recalculated when the file is opened
forceFormulaRefresh("/tmp/file.xlsx")
forceFormulaRefresh("/tmp/file.xlsx", "/tmp/fixed_file.xlsx")

## End(Not run)

colearendt/xlsx documentation built on Oct. 11, 2018, 12:23 a.m.