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 + file LICENSE |
| URL: | https://github.com/nacnudus/tidyxl, https://nacnudus.github.io/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.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, gasanalyzer, scicomptools, seahtrue, unheadr, xlcutter |
| Reverse suggests: | unpivotr |
Please use the canonical form https://CRAN.R-project.org/package=tidyxl to link to this page.