Load (xlsread) a especific time sample

Question

Sérgio Querido 2017-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332428-load-xlsread-a-especific-time-sample

评论： Star Strider 2017-3-29

TEST.csv

In spreadsheet attached, how can i do a rotine to load (with xlsread) a especific time sample (example: 00:01:24 to 00:05:03)?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-3-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332428-load-xlsread-a-especific-time-sample#answer_260788

在 MATLAB Online 中打开

If your file is formatted the same as in Heart Rate by category, you cannot. You have to read the entire file, parse the column, Convert to the appropriate formats, then do the selections:

[~,sc] = xlsread('TEST.csv');
t_rc = regexp(sc(2:end), ';','split');                      % Parse Column
dn = cellfun(@(x) datenum(x(:,1), 'HH:MM:SS'), t_rc);       % Convert To Date Numbers
hr = cellfun(@(x) str2double(x(:,2)), t_rc);                % Convert To Doubles

2 个评论
显示无隐藏无

Sérgio Querido 2017-3-29

Ok!! Do you know the code to do the selection, after appropriate formats??

Star Strider 2017-3-29

在 MATLAB Online 中打开

Yes!

The Code —

[~,sc] = xlsread('Sérgio Querido TEST.csv');
t_rc = regexp(sc(2:end), ';','split');                      % Parse Column
dn = cellfun(@(x) datenum(x(:,1), 'HH:MM:SS'), t_rc);
hr = cellfun(@(x) str2double(x(:,2)), t_rc);
dn_range = datenum(['00:01:24'; '00:05:03'],  'HH:MM:SS');
idx = find((dn >= dn_range(1)) & (dn <= dn_range(2)));