Package: unexcel 0.2.0

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.

Authors:Hercules R. Freitas [aut, cre, cph]

unexcel_0.2.0.tar.gz
unexcel_0.2.0.zip(r-4.7-any)unexcel_0.2.0.zip(r-4.6-any)unexcel_0.2.0.zip(r-4.5-any)
unexcel_0.2.0.tgz(r-4.6-any)unexcel_0.2.0.tgz(r-4.5-any)
unexcel_0.2.0.tar.gz(r-4.7-any)unexcel_0.2.0.tar.gz(r-4.6-any)
unexcel_0.2.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
unexcel/json (API)

# Install 'unexcel' in R:
install.packages('unexcel', repos = c('https://drhrf.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/drhrf/unexcel/issues

Pkgdown/docs site:https://drhrf.github.io

On CRAN:

Conda:

4.00 score 236 downloads 9 exports 3 dependencies

Last updated from:46989fb1ed. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK123
source / vignettesOK172
linux-releaseOK114
macos-releaseOK144
macos-oldrelOK165
windows-develOK67
windows-releaseOK61
windows-oldrelOK57
wasm-releaseOK104

Exports:excel_date_cellsexcel_date_columnsexcel_date_systemexcel_originexcel_sheetsfix_serial_columnsrestore_day_monthserial_to_day_monthunexcel_xlsx

Dependencies:clirlangxml2

Excel date systems and number formats
Serials | Two origins | Number formats | What is still lost | Further reading

Last update: 2026-07-27
Started: 2026-07-27

Getting started with unexcel
The problem | The recommended path: read the workbook | Where the certainty comes from | Sheets, headers and output types | When the workbook is gone | Meeting in the middle | Summary

Last update: 2026-07-27
Started: 2026-07-27