tidyxl: Read Untidy Excel Files

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

Documentation:

Reference manual: tidyxl.pdf
Vignettes: Data Validation Rules
Detecting Spreadsheet Smells with xlex()
Tidyxl

Downloads:

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 dependencies:

Reverse imports: eCerto, gasanalyzer, scicomptools, unheadr, xlcutter
Reverse suggests: unpivotr

Linking:

Please use the canonical form https://CRAN.R-project.org/package=tidyxl to link to this page.