{ "_id": "6acccfdda14063b82c3a9779", "Package": "unexcel", "Title": "Revert Spreadsheet Date Auto-Conversion to the Numbers Typed", "Version": "0.2.0", "Authors@R": "c(\nperson(given = \"Hercules R.\",\nfamily = \"Freitas\",\nrole = c(\"aut\", \"cre\", \"cph\"),\nemail = \"hercules.freitas@uerj.br\",\ncomment = c(ORCID = \"0000-0003-1584-9157\")))", "Description": "Spreadsheets silently turn entries such as '30.3' into\ndates, so the imported data carry date serials instead of the\nnumbers that were typed. Reading the workbook directly recovers\nthose numbers without guesswork: an 'xlsx' file states its own\ndate system, and records which cells are formatted as dates and\nin which field order, so the values to repair are identified\nfrom the file rather than inferred from their magnitude.\nFunctions are also provided for data already imported, where\nthat evidence is no longer available, using conservative and\nconfigurable detection.", "License": "MIT + file LICENSE", "URL": "https://github.com/drhrf/unexcel, https://drhrf.github.io/unexcel/", "BugReports": "https://github.com/drhrf/unexcel/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "Config/testthat/edition": "3", "Config/Needs/website": "pkgdown", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "libxml2-dev", "Repository": "https://drhrf.r-universe.dev", "Date/Publication": "2026-07-27 17:43:51 UTC", "RemoteUrl": "https://github.com/drhrf/unexcel", "RemoteRef": "HEAD", "RemoteSha": "46989fb1edf8b78b7334db27e7600b8d432466ad", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-12 12:13:54 UTC", "User": "root" }, "Author": "Hercules R. Freitas [aut, cre, cph] (ORCID:\n)", "Maintainer": "Hercules R. Freitas ", "_user": "drhrf", "_type": "src", "_file": "unexcel_0.2.0.tar.gz", "_fileid": "https://r2.ropensci.org/0f51145598cf72fa66901de536c31b4f67284e1ffb88796e668098730ff71878", "_filesize": 193396, "_sha256": "0f51145598cf72fa66901de536c31b4f67284e1ffb88796e668098730ff71878", "_expires": "2027-01-20T12:17:32.000Z", "_created": "2026-10-12T12:13:54.000Z", "_published": "2026-10-12T12:17:33.776Z", "_buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 114805840195, "time": 123, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11746049246" }, { "job": 114805840154, "time": 114, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11746483945" }, { "job": 114805840039, "time": 165, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11746728862" }, { "job": 114805840202, "time": 144, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11746204107" }, { "job": 114804789498, "time": 172, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11746728411" }, { "job": 114805840024, "time": 104, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11746014183" }, { "job": 114805840317, "time": 67, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11746433787" }, { "job": 114805840140, "time": 57, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11746133957" }, { "job": 114805840239, "time": 61, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11746693668" } ], "_upstream": "https://github.com/drhrf/unexcel", "_commit": { "id": "46989fb1edf8b78b7334db27e7600b8d432466ad", "author": "Hercules Rezende Freitas ", "committer": "Hercules Rezende Freitas ", "message": "CRAN sub V.0.2.0\n", "time": 1785174231 }, "_maintainer": { "name": "Hercules R. Freitas", "email": "hercules.freitas@uerj.br", "login": "drhrf", "orcid": "0000-0003-1584-9157", "description": "", "uuid": 91353422 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6", "role": "Depends" }, { "package": "stats", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "xml2", "version": ">= 1.3.0", "role": "Imports" }, { "package": "knitr", "version": ">= 1.40", "role": "Suggests" }, { "package": "pkgdown", "version": ">= 2.0.0", "role": "Suggests" }, { "package": "rmarkdown", "version": ">= 2.20", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "drhrf", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-31", "n": 5 } ], "_tags": [], "_stars": 0, "_contributors": [ { "user": "drhrf", "count": 8, "uuid": 91353422 } ], "_userbio": { "uuid": 91353422, "type": "user", "name": "drhrf", "followers": 3 }, "_downloads": { "count": 236, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/unexcel" }, "_devurl": "https://github.com/drhrf/unexcel", "_pkgdown": "https://drhrf.github.io/unexcel/", "_searchresults": 0, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/unexcel.html", "LICENSE" ], "_homeurl": "https://github.com/drhrf/unexcel", "_realowner": "drhrf", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2025-10-08" }, { "version": "0.2.0", "date": "2026-07-28" } ], "_exports": [ "excel_date_cells", "excel_date_columns", "excel_date_system", "excel_origin", "excel_sheets", "fix_serial_columns", "restore_day_month", "serial_to_day_month", "unexcel_xlsx" ], "_help": [ { "page": "excel_date_cells", "title": "Find the cells a workbook formats as dates", "topics": [ "excel_date_cells" ] }, { "page": "excel_date_columns", "title": "Summarise date-formatted cells by column", "topics": [ "excel_date_columns" ] }, { "page": "excel_date_system", "title": "Read the date system a workbook declares", "topics": [ "excel_date_system" ] }, { "page": "excel_origin", "title": "The origin date behind each Excel date system", "topics": [ "excel_origin" ] }, { "page": "excel_sheets", "title": "List the sheets in a workbook", "topics": [ "excel_sheets" ] }, { "page": "fix_serial_columns", "title": "Revert Excel date serials across a data frame", "topics": [ "fix_serial_columns" ] }, { "page": "restore_day_month", "title": "Revert Excel date serials in an already-imported vector", "topics": [ "restore_day_month" ] }, { "page": "serial_to_day_month", "title": "Convert Excel date serials to 'day.month' values", "topics": [ "serial_to_day_month" ] }, { "page": "unexcel_xlsx", "title": "Read an '.xlsx' sheet and undo its date auto-conversion", "topics": [ "unexcel_xlsx" ] } ], "_pkglogo": "https://github.com/drhrf/unexcel/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/drhrf/unexcel/raw/HEAD/README.md", "_rundeps": [ "cli", "rlang", "xml2" ], "_vignettes": [ { "source": "excel-date-systems.Rmd", "filename": "excel-date-systems.html", "title": "Excel date systems and number formats", "engine": "knitr::rmarkdown", "headings": [ "Serials", "Two origins", "Number formats", "What is still lost", "Further reading" ], "created": "2026-07-27 14:40:21", "modified": "2026-07-27 14:40:21", "commits": 1 }, { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started with unexcel", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-07-27 14:40:21", "modified": "2026-07-27 14:40:21", "commits": 1 } ], "_score": 4, "_indexed": true, "_nocasepkg": "unexcel", "_universes": [ "drhrf" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.0", "date": "2026-10-12T12:16:00.000Z", "distro": "resolute", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/090db72418676f0a2c2c9c25cd70f1c3c778783bc504624ab7d18722a13c191e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.6.1", "os": "linux", "version": "0.2.0", "date": "2026-10-12T12:15:50.000Z", "distro": "resolute", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/95c61005dbb891bf74f9ff6acc7447f06346433f7a2cbd9dafaac2a8aeac44b7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.5.3", "os": "mac", "version": "0.2.0", "date": "2026-10-12T12:16:21.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/b6da23e94a717079d06d06ba586a2a449e006ffd7ce1787a8d27a905d7d2d2da", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.6.1", "os": "mac", "version": "0.2.0", "date": "2026-10-12T12:16:02.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/36805698909122b3f8937a69e92bacd58f0ac626eeba2c889abfe68ede4d7084", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.0", "date": "2026-10-12T12:15:52.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/86806458af3988e1577805adf1273d78c50cc5fb6fce49477ab85242c38ce332", "status": "success", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.7.0", "os": "win", "version": "0.2.0", "date": "2026-10-12T12:14:56.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/b529e2122e7d4121d7f790965788b1bc69805f0a0c2a80c49a19d14b78af1e4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.5.3", "os": "win", "version": "0.2.0", "date": "2026-10-12T12:14:53.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/f1703d0b5ec02453d89789efce2f50bcac81276d56fb2c55d790de58934bdf95", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" }, { "r": "4.6.1", "os": "win", "version": "0.2.0", "date": "2026-10-12T12:14:54.000Z", "commit": "46989fb1edf8b78b7334db27e7600b8d432466ad", "fileid": "https://r2.ropensci.org/ed509d642a2a9e33e69633caaa3482b498d98cd54dd35499df1e180567b03ecb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/38247408936" } ] }