Importing excel time data
65 views (last 30 days)
Show older comments
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 Comment
Answers (1)
Luca Ferro
on 24 May 2023
I think you can find your solution here https://it.mathworks.com/matlabcentral/answers/25216-reading-time-dates-from-excel
4 Comments
Mathieu NOE
on 25 May 2023
make sure you have read / write permission on your path
are you sure you are not working in a windows protected path ?
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!