GitHub - drhrf/unexcel: Detects values imported from spreadsheets that were auto-converted to Excel date serials and reconstructs the originally intended day.month decimals.

drhrf / unexcel Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Detects values imported from spreadsheets that were auto-converted to Excel date serials and reconstructs the originally intended day.month decimals.

Unknown, MIT licenses found

Licenses found

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
R		R
man		man
vignettes		vignettes
.Rbuildignore		.Rbuildignore
.gitignore		.gitignore
CRAN-SUBMISSION		CRAN-SUBMISSION
DESCRIPTION		DESCRIPTION
LICENSE		LICENSE
LICENSE.md		LICENSE.md
NAMESPACE		NAMESPACE
README		README
cran-comments.md		cran-comments.md
unexcel.Rproj		unexcel.Rproj

Repository files navigation

# unexcel

Detect and revert spreadsheet auto-converted Excel date serials back to the intended `day.month` numerics.  

This package provides functions to identify values imported as Excel date serials (for example, `45812` representing 2025-03-30) and reconstruct the original numeric entry such as `30.3`. Non-serial values are preserved, and both the 1900 and 1904 date systems are supported.

## Installation

You can install the development version from GitHub with:

```r
# install.packages("remotes")
remotes::install_github("drhrf/unexcel")
```

## Example

```r
library(unexcel)

# 45812 is 2025-03-30 in Excel's 1900 system
x <- c(45812, 12.5, 44730)

restore_day_month(x, origin_mode = "1900")
#> [1] 30.3 12.5 15.6
```