Extract Excel files from folder. Also display extracted data and compute a summary of it. Based on the 'readxl' package.
The xlutils3
package is a wrapper for the readxl
package. It aims to extract all Excel files of a folder at once.
You can install:
# install.packages("devtools")devtools::install_git("ssh://[email protected]:42/aurele/xlutils3.git")
# install.packages("devtools")devtools::install_github("eaurele/xlutils3")
library(xlutils3) # Extract all Excel files from folder, recursively:data_ <- extract_excel("./Folder full of Excel files/") # Compute summary of extracted data as a dataframeView(summary_excel(data_)) # View all extracted dataview_excel(data_)
readxl::excel_read
for all files, or for specific files. (See general_case
and weird_cases
parameters for extract_excel
).