Last chance! 50% off unlimited learning
Sale ends in
Reads one sheet (or all sheets) from each of the Excel files in a folder and
creates a list of pivot_table objects, one from each sheet. Each sheet is
expected to contain a pivot table. Each line in a file corresponds to a row
in a table. File and sheet names are included as part of each object
attributes.
read_excel_folder(folder, sheetIndex = 1, sheetName = NULL, allSheets = FALSE)A pivot_table object list.
A string, folder name.
A number, sheet index in the workbook.
A string, sheet name.
A boolean.
When multiple files or sheets are handled, the file and/or sheet names may
contain information associated with the pivot table, they could be the table
page information. In order not to lose this information, they are always
stored in each pivot_table object.
Other import functions:
pivot_table(),
read_excel_file(),
read_excel_sheet(),
read_text_file(),
read_text_folder()
folder <- system.file("extdata", "excelfolder", package = "flattabler")
lpt <- read_excel_folder(folder)
lpt <- read_excel_folder(folder, allSheets = TRUE)
Run the code above in your browser using DataLab