How to read time as string data from excel file
15 views (last 30 days)
Show older comments
Yasuyuki Hamanaka
on 24 May 2021
Commented: Yasuyuki Hamanaka
on 24 May 2021
I used readtable to read time from excel spread sheets. The time was converted to double like e.x. But I want to read time as original form. How does read time as string?
e.x 10:11:09 AM => 0.42858
0 Comments
Accepted Answer
Yutaka Yamada
on 24 May 2021
How about the below code if you want to use readtable?
opts = detectImportOptions('readTime.xlsx');
opts.VariableTypes = 'datetime';
T = readtable('readTime.xlsx', opts);
for i = 1:3
a = T{i, 1};
a.Format = 'HH:mm:ss a';
end
I've attached the Excel file that I've used for this test also.
3 Comments
More Answers (1)
Sulaymon Eshkabilov
on 24 May 2021
Hi,
You should try using xlsread() in this case. In fact, xlsread is slower than readtable().
Then you can employ datenum() and datestr() if necessary.
Good luck.
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!