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.