Extract Multiple Excel Files at Once

Extract Excel files from folder. Also display extracted data and compute a summary of it. Based on the 'readxl' package.


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:

  • the latest development version from Saagie internal Gitlab (requires an account):
# install.packages("devtools")
devtools::install_git("ssh://[email protected]:42/aurele/xlutils3.git")
  • or from Github:
# install.packages("devtools")
devtools::install_github("eaurele/xlutils3")
  • or maybe from CRAN (some day).

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

  • Allows to pass args to readxl::excel_read for all files, or for specific files. (See general_case and weird_cases parameters for extract_excel).

News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("xlutils3")

0.1.0 by Aurele Morvan, 3 years ago


Browse source code at https://github.com/cran/xlutils3


Authors: Aurele Morvan [aut, cre]


Documentation:   PDF Manual  


GPL-3 license


Imports magrittr, readxl

Suggests testthat


See at CRAN