xlutils3

Travis-CI Build Status Coverage Status

The xlutils3 package is a wrapper for the readxl package. It aims to extract all Excel files of a folder at once.

Installation

You can install:

# install.packages("devtools")
devtools::install_git("ssh://git@gitlab.saagie.tech:42/aurele/xlutils3.git")
# install.packages("devtools")
devtools::install_github("eaurele/xlutils3")

Usage

library(xlutils3)

# Extract all Excel files from folder, recursively:
data_ <- extract_excel("./Folder full of Excel files/")

# Compute summary of extracted data as a dataframe
View(summary_excel(data_))

# View all extracted data
view_excel(data_)

Features