autoRefresh: Force Refresh Pivot Tables and Formulae

In xlsx: Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

Description

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

Usage

forceFormulaRefresh(file, output = NULL, verbose = FALSE)

forcePivotTableRefresh(file, output = NULL, verbose = FALSE)

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	Whether to make logging more verbose

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

Does not return any results

Author(s)

Tom Kwong

Examples

# Patch a file where its pivot tables are not recalculated when the file is opened
## Not run: 
forcePivotTableRefresh("/tmp/file.xlsx")
forcePivotTableRefresh("/tmp/file.xlsx", "/tmp/fixed_file.xlsx")

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

## End(Not run)

xlsx documentation built on Nov. 10, 2020, 3:52 p.m.