search

ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
220 stars 73 forks source link

openxlsx can not convert date/time serial numbers #428

Closed kirklucy closed 2 months ago

kirklucy commented 1 year ago

when reading an excel file with date & time the detectDates = TRUE does not convert the date/time serial number. the worst part is that it truncates the numbest so when using Date.Time = as.POSIXct("df.reference", origin = "2015-10-29") the date is correct but the %H:%M:%S are incorrect.

github-actions[bot] commented 2 months ago

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

github-actions[bot] commented 2 months ago

This issue was closed because it has been stalled for 7 days with no activity.