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 <https://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.
| Version: | 1.0.10 |
| Depends: | R (≥ 3.2.0) |
| Imports: | Rcpp |
| LinkingTo: | Rcpp,piton (≥ 1.0.0) |
| Suggests: | testthat,here,knitr,rmarkdown,readxl,dplyr,tidyr,purrr,tibble,ggplot2,cellranger,openxlsx,rlang |
| Published: | 2023-12-21 |
| DOI: | 10.32614/CRAN.package.tidyxl |
| 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: | MIT + fileLICENSE |
| URL: | https://github.com/nacnudus/tidyxl,https://nacnudus.github.io/tidyxl/ |
| NeedsCompilation: | yes |
| Materials: | README,NEWS |
| CRAN checks: | tidyxl results |
| Reference manual: | tidyxl.html ,tidyxl.pdf |
| Vignettes: | Data Validation Rules (source,R code) Detecting Spreadsheet Smells with xlex() (source,R code) Tidyxl (source,R code) |
| Package source: | tidyxl_1.0.10.tar.gz |
| Windows binaries: | r-devel:tidyxl_1.0.10.zip, r-release:tidyxl_1.0.10.zip, r-oldrel:tidyxl_1.0.10.zip |
| macOS binaries: | r-release (arm64):tidyxl_1.0.10.tgz, r-oldrel (arm64):tidyxl_1.0.10.tgz, r-release (x86_64):tidyxl_1.0.10.tgz, r-oldrel (x86_64):tidyxl_1.0.10.tgz |
| Old sources: | tidyxl archive |
| Reverse imports: | eCerto,forgts,gasanalyzer,readapra,scicomptools,seahtrue,unheadr,xlcutter |
| Reverse suggests: | unpivotr |
Please use the canonical formhttps://CRAN.R-project.org/package=tidyxlto link to this page.