I am loading data from an Excel file that includes DateTime data. The DateTime string, when the time is 0:00 is parsed as a Date instead of a DateTime. An example of the data being loaded is: Date a 2023-07-11 0:00 45.12 2023-07-11 0:01 45.14 2023-07-11 0:02 45.09 2023-07-11 0:03 44.69 2023-07-12…

XLSX parsing DateTime

nilshg August 22, 2023, 3:31pm 2

Seems worth opening an issue on the XLSX repo.

Topic		Replies	Views
00:00:00 to 1899-12-30 bug with XLSX New to Julia	2	506	November 6, 2018
Converting XLSX.Worksheet to DataFrame Data xlsx , excel	5	1219	February 16, 2024
Converting columns in a DataFrame from String to Date (with a specific format) General Usage dates , dataframes	14	3696	October 10, 2022
XLSX and DataFrame column type General Usage dataframes , makie , xlsx , cairomakie	3	501	February 25, 2024
Converting DateTime in DataFrames indo Data New to Julia question , dates , dataframes	9	606	April 15, 2021