unexcel: Revert Spreadsheet Date Auto-Conversion to the Numbers Typed
Spreadsheets silently turn entries such as '30.3' into dates, so the imported data carry date serials instead of the numbers that were typed. Reading the workbook directly recovers those numbers without guesswork: an 'xlsx' file states its own date system, and records which cells are formatted as dates and in which field order, so the values to repair are identified from the file rather than inferred from their magnitude. Functions are also provided for data already imported, where that evidence is no longer available, using conservative and configurable detection.
| Version: | 0.2.0 |
| Depends: | R (≥ 3.6) |
| Imports: | stats, utils, xml2 (≥ 1.3.0) |
| Suggests: | knitr (≥ 1.40), pkgdown (≥ 2.0.0), rmarkdown (≥ 2.20), testthat (≥ 3.0.0) |
| Published: | 2026-07-28 |
| DOI: | 10.32614/CRAN.package.unexcel |
| Author: | Hercules R. Freitas
 [aut, cre,
cph] |
| Maintainer: | Hercules R. Freitas <hercules.freitas at uerj.br> |
| BugReports: | https://github.com/drhrf/unexcel/issues |
| License: | MIT + file LICENSE |
| URL: | https://github.com/drhrf/unexcel, https://drhrf.github.io/unexcel/ |
| NeedsCompilation: | no |
| Language: | en-US |
| Materials: | README, NEWS |
| CRAN checks: | unexcel results |
Documentation:
| Reference manual: | unexcel.html , unexcel.pdf |
| Vignettes: |
Excel date systems and number formats (source, R code) Getting started with unexcel (source, R code) |
Downloads:
| Package source: | unexcel_0.2.0.tar.gz |
| Windows binaries: | r-devel: unexcel_0.2.0.zip, r-release: unexcel_0.1.0.zip, r-oldrel: unexcel_0.1.0.zip |
| macOS binaries: | r-release (arm64): unexcel_0.2.0.tgz, r-oldrel (arm64): unexcel_0.2.0.tgz, r-release (x86_64): unexcel_0.2.0.tgz, r-oldrel (x86_64): unexcel_0.2.0.tgz |
| Old sources: | unexcel archive |
Linking:
Please use the canonical form https://CRAN.R-project.org/package=unexcel to link to this page.