Excel Columns to Matlab Array

48 次查看（过去 30 天）
Sarah Shi
Sarah Shi 2019-7-8
回答： Star Strider 2019-7-8
Hi! I am currently working on a 701x20 matrix of collected data and am trying to convert each column of data to a MATLAB array with a for loop. I am trying to avoid typing out something like this:
time = euh2(:, 1)';
li7 = euh2(:, 2)';
mg25 = euh2(:, 3)';
mg26 = euh2(:, 4)';
My data (named euh2) look like this:Screen Shot 2019-07-08 at 14.13.39.png
I've tried something these lines and am not having much success.
columns = zeros(1, length(euh2));
for ii = 1:20
columns(ii) = euh2(:, ii);
end
Any help would be greatly appreciated! Thank you!

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

回答（2 个）

Tatvam Dadheech
Tatvam Dadheech 2019-7-8
Star Strider
Star Strider 2019-7-8
I would use the readtable function if your have R2013b or later.
You can probably then convert it into a timetable array (R2016b or later) if the ‘Time’ values are imortant and you can parse them into something useful that datetime (R2014b or later) can interpret. It is not currently obvious what their units are, or how to interpret them.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by