openxlsx (version 4.2.3)

getDateOrigin: Get the date origin an xlsx file is using

Description

Return the date origin used internally by an xlsx or xlsm file

Usage

getDateOrigin(xlsxFile)

Arguments

xlsxFile

An xlsx or xlsm file.

Value

One of "1900-01-01" or "1904-01-01".

Details

Excel stores dates as the number of days from either 1904-01-01 or 1900-01-01. This function checks the date origin being used in an Excel file and returns is so it can be used in convertToDate

See Also

convertToDate

Examples

Run this code
# NOT RUN {
## create a file with some dates
# }
# NOT RUN {
write.xlsx(as.Date("2015-01-10") - (0:4), file = "getDateOriginExample.xlsx")
m <- read.xlsx("getDateOriginExample.xlsx")

## convert to dates
do <- getDateOrigin(system.file("extdata", "readTest.xlsx", package = "openxlsx"))
convertToDate(m[[1]], do)
# }

Run the code above in your browser using DataCamp Workspace