How to import timestamp from excel

17 次查看（过去 30 天）
jchris14
jchris14 2016-8-1
移动：Dyuman Joshi 2023-10-12
I have a large data set and the first and second column are date and time followed by other parameter readings. When i import this excel into MATLAB, the timestamp, for example: 0:00:02 gets imported as 2e-5. How do I format it to say 0:00:02 or something more proper so that i can plot the data?
Thanks for the help

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2016-8-1
If your time vector is in the first column for example
[a,b,c]=xlsread('d1.xlsx')
out=datestr(a(:,1),'HH:MM:SS')

更多回答（1 个）

Bradley
Bradley 2023-10-12
Just a bump, updated for Matlab 2022b:
To read data from an Excel file which includes time stamps, a couple of things: datestr is obsolete, and datatime is preferred. However, I had issues using datetime directly. Instead, I did it like this, for data contained in a range from A1 to Z100, with the time stamps contained in column A:
full_data = readtable(filename,'Sheet','Sheet Name','Range','A1:Z100','ReadVariableNames',0);
time_data = table2array(full_data(:,1));
% Note: table2array seems to automatically detect the source format by default, so the answer comes in as datetime
From there, you can do any normal thing... I found a couple of follow-up things like this:
dt = seconds(mean(diff(time_data)));
time_max = seconds(time_data(end) - time_data(1));
sim_time = 0:dt:time_max;
I'm sure the table2array call has some default 'opts' which make the formatting just happen to work out nicely for me. I didn't bother to dig deeper on that.
Thanks!

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by