Load (xlsread) a especific time sample
显示 更早的评论
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)?
回答（1 个）
Star Strider
2017-3-29
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
Star Strider
2017-3-29
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)));
The ‘idx’ variable has the row indices for the times that meet the criteria.
类别
在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息
2017-3-28
2017-3-29
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
