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.6 |
| Depends: | R (≥ 3.2.0) |
| Imports: | Rcpp |
| LinkingTo: | Rcpp, piton |
| Suggests: | testthat, here, knitr, rmarkdown, readxl, dplyr, tidyr, purrr, tibble, ggplot2, cellranger, openxlsx, rlang |
| Published: | 2020-05-09 |
| Author: | Duncan Garmonsway [aut, cre], Hadley Wickham [ctb] (Author of included readxl fragments), Jenny Bryan [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.6.tar.gz |
| Windows binaries: | r-devel: tidyxl_1.0.6.zip, r-release: tidyxl_1.0.6.zip, r-oldrel: tidyxl_1.0.6.zip |
| macOS binaries: | r-release: tidyxl_1.0.6.tgz, r-oldrel: tidyxl_1.0.6.tgz |
| Old sources: | tidyxl archive |
| Reverse imports: | unheadr |
| Reverse suggests: | unpivotr |
Please use the canonical form https://CRAN.R-project.org/package=tidyxl to link to this page.