Read Untidy Excel Files

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 < http://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.


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("tidyxl")

0.2.1 by Duncan Garmonsway, 23 days ago


https://github.com/nacnudus/tidyxl


Report a bug at https://github.com/nacnudus/tidyxl/issues


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


Authors: Duncan Garmonsway [aut, cre], Hadley Wickham [ctb] (Author of included readxl fragments), RStudio [cph] (Copyright holder of included readxl fragments), Marcin Kalicinski [ctb, cph] (Author of included RapidXML code)


Documentation:   PDF Manual  


GPL-3 license


Imports Rcpp

Suggests testthat, knitr, rmarkdown, readxl

Linking to Rcpp


Suggested by unpivotr.


See at CRAN