Importing excel time data
37 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I am trying to read an excel file containg the date and time in the format "dd/mm/yyyy HH:MM:SS". (The excel contains eight columns [Date, Time, data1, data2, data3,data4,data5,data6,data7,data8])
I read the excel file with the code
opts = detectImportOptions("LW.xlsx");
T = readtable("LW.xlsx",opts)
T = table2timetable(T)
Time =datetime(T.Time, "ConverFrom", "datenum", "Format", "HH:mm:ss");
Date =datetime(T.Date, "ConverFrom", "datenum", "Format", "dd/MM/yyyy");
TD = mergevars(T,{"Date","Time"},...
"NewVariableName","DateTime", "MergeAsTable",true);
I get error message when I try table2timetable and also when I try to merge Time and Date
How do I fix this please.
1 Kommentar
Antworten (1)
Luca Ferro
am 24 Mai 2023
I think you can find your solution here https://it.mathworks.com/matlabcentral/answers/25216-reading-time-dates-from-excel
4 Kommentare
Mathieu NOE
am 25 Mai 2023
make sure you have read / write permission on your path
are you sure you are not working in a windows protected path ?
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!