Excel Columns to Matlab Array

2019 7 8
2 个回答
更新时间：2019 7 8
17 次查看（30 天）

0 个投票

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 个）

Star Strider
Star Strider 2019-7-8

0 个投票

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.

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by