xlsxPivotCacheExtractor: xlsxPivotCacheExtractor

View source: R/xlsxPivotCacheExtractor.R

xlsxPivotCacheExtractorR Documentation

xlsxPivotCacheExtractor

Description

Extract the hidden table that feeds excel pivot tables. Each pivot table is extracted from the excel file.

Usage

xlsxPivotCacheExtractor(file)

Arguments

file

An excel xlsx file with pivot tables.

Value

a list of dataframes, one for each pivot table cache in the excel file.

Examples

xlsxPivotCacheExtractor(file = system.file("extdata/test_sheet.xlsx",
package = "btools",mustWork = TRUE))

bwaite-esr/btools documentation built on Sept. 28, 2023, 5:26 p.m.