convert_date: Convert from Excel date, datetime or hms number to R Date...

In openxlsx2: Read, Write and Edit 'xlsx' Files

Convert from Excel date, datetime or hms number to R Date type

Description

Convert from Excel date number to R Date type

Usage

convert_date(x, origin = "1900-01-01", ...)

convert_datetime(x, origin = "1900-01-01", ...)

convert_hms(x)

Arguments

x	A vector of integers
origin	date. Default value is for Windows Excel 2010
...	Arguments passed on to base::as.Date.character format a character string. If not specified when converting from a character representation, it will try tryFormats one by one on the first non-NA element, and give an error if none works. Otherwise, the processing is via strptime() whose help page describes available conversion specifications. tryFormats character vector of format strings to try if format is not specified. optional logical indicating to return NA (instead of signalling an error) if the format guessing does not succeed.

Details

Excel stores dates as number of days from some origin day

Value

A date, datetime, or hms.

See Also

wb_add_data()

Examples

# date --
## 2014 April 21st to 25th
convert_date(c(41750, 41751, 41752, 41753, 41754, NA))
convert_date(c(41750.2, 41751.99, NA, 41753))

# datetime --
##  2014-07-01, 2014-06-30, 2014-06-29
x <- c(41821.8127314815, 41820.8127314815, NA, 41819, NaN)
convert_datetime(x)
convert_datetime(x, tz = "Australia/Perth")
convert_datetime(x, tz = "UTC")

# hms ---
## 12:13:14
x <- 0.50918982
convert_hms(x)

openxlsx2 documentation built on April 3, 2025, 8:40 p.m.