Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Provides functions for selecting cells by position and relative position, and for associating data cells with header cells by proximity in given directions. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library . Does not support '.xlsb' or '.xls'.

Documentation

Manual: tidyxl.pdf
Vignette: Tidyxl

Maintainer: Duncan Garmonsway <nacnudus at gmail.com>

Author(s): Duncan Garmonsway*, Hadley Wickham* (Author of included readxl fragments), RStudio* (Copyright holder of included readxl fragments), Marcin Kalicinski* (Author of included RapidXML code)

Install package and any missing dependencies by running this line in your R console:

install.packages("tidyxl")

Depends R (>= 3.2.0)
Imports Rcpp
Suggests testthat, knitr, rmarkdown, readxl
Enhances
Linking to Rcpp
Reverse
depends
Reverse
imports
Reverse
suggests
unpivotr
Reverse
enhances
Reverse
linking to

Package tidyxl
Materials
URL https://github.com/nacnudus/tidyxl
Task Views
Version 0.2.1
Published 2017-01-29
License GPL-3
BugReports https://github.com/nacnudus/tidyxl/issues
SystemRequirements
NeedsCompilation yes
Citation
CRAN checks tidyxl check results
Package source tidyxl_0.2.1.tar.gz