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:
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
Last updated from:46989fb1ed. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 123 | ||
| source / vignettes | OK | 172 | ||
| linux-release | OK | 114 | ||
| macos-release | OK | 144 | ||
| macos-oldrel | OK | 165 | ||
| windows-devel | OK | 67 | ||
| windows-release | OK | 61 | ||
| windows-oldrel | OK | 57 | ||
| wasm-release | OK | 104 |
Exports:excel_date_cellsexcel_date_columnsexcel_date_systemexcel_originexcel_sheetsfix_serial_columnsrestore_day_monthserial_to_day_monthunexcel_xlsx
Last update: 2026-07-27
Started: 2026-07-27
Last update: 2026-07-27
Started: 2026-07-27
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Find the cells a workbook formats as dates | excel_date_cells |
| Summarise date-formatted cells by column | excel_date_columns |
| Read the date system a workbook declares | excel_date_system |
| The origin date behind each Excel date system | excel_origin |
| List the sheets in a workbook | excel_sheets |
| Revert Excel date serials across a data frame | fix_serial_columns |
| Revert Excel date serials in an already-imported vector | restore_day_month |
| Convert Excel date serials to 'day.month' values | serial_to_day_month |
| Read an '.xlsx' sheet and undo its date auto-conversion | unexcel_xlsx |
