datetimeutils (version 0.6-4)

date1904: Is File Origin 1904?

Description

Checks whether an xlsx file uses 1 Jan 1904 as its origin.

Usage

date1904(filename)

Value

A logical vector:

TRUE if origin is 1904;

FALSE if origin is 1900;

NA if file could not be processed.

Arguments

filename

character: one or more filenames

Author

Enrico Schumann; type spss/pspp suggested and based on a patch by J\"org Beyer

Details

Requires utils::unzip.

References

ECMA-376-1:2016 Office Open XML File Formats.

See Also

convert_date

Examples

# \donttest{
date1904("~/Desktop/02_company_statistics.pdf")
# }