Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <http://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.
| Version: | 1.0.0 |
| Depends: | R (≥ 3.2.0) |
| Imports: | Rcpp |
| LinkingTo: | Rcpp, piton |
| Suggests: | testthat, here, knitr, rmarkdown, readxl, dplyr, tidyr, purrr, ggplot2, cellranger, rlang |
| Published: | 2017-11-25 |
| 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: |
Data Validation Rules Detecting Spreadsheet Smells with xlex() Tidyxl |
| Package source: | tidyxl_1.0.0.tar.gz |
| Windows binaries: | r-devel: tidyxl_1.0.0.zip, r-release: tidyxl_1.0.0.zip, r-oldrel: tidyxl_1.0.0.zip |
| OS X El Capitan binaries: | r-release: tidyxl_1.0.0.tgz |
| OS X Mavericks binaries: | r-oldrel: tidyxl_1.0.0.tgz |
| Old sources: | tidyxl archive |
| Reverse suggests: | unpivotr |
Please use the canonical form https://CRAN.R-project.org/package=tidyxl to link to this page.