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'.
Version: | 0.2.1 |
Depends: | R (≥ 3.2.0) |
Imports: | Rcpp |
LinkingTo: | Rcpp |
Suggests: | testthat, knitr, rmarkdown, readxl |
Published: | 2017-01-29 |
Author: | 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) |
Maintainer: | Duncan Garmonsway <nacnudus at gmail.com> |
BugReports: | https://github.com/nacnudus/tidyxl/issues |
License: | GPL-3 |
URL: | https://github.com/nacnudus/tidyxl |
NeedsCompilation: | yes |
Materials: | README NEWS |
CRAN checks: | tidyxl results |
Reference manual: | tidyxl.pdf |
Vignettes: |
Tidyxl |
Package source: | tidyxl_0.2.1.tar.gz |
Windows binaries: | r-devel: tidyxl_0.2.1.zip, r-release: tidyxl_0.2.1.zip, r-oldrel: tidyxl_0.2.1.zip |
OS X Mavericks binaries: | r-release: tidyxl_0.2.1.tgz, r-oldrel: tidyxl_0.2.1.tgz |
Reverse suggests: | unpivotr |
Please use the canonical form https://CRAN.R-project.org/package=tidyxl to link to this page.