How to load multiple excel files using a loop into MATLAB

2017 6 17
1 个回答
回答已采纳
更新时间：2017 6 20
11 次查看（30 天）

1 个投票

Hi,
I have 58 excel files ( S (i).xlsx) and i want to load them all into MATLAB then store them in to two different cells (odd in one and even in another) I can do it one by one but it takes heaps of time. Can you please help me about this?
for i = 1:2:57;
j = 0:2:58;
x_data1 = sprintf('S (%d).xlsx',i);
x_cal = xlsread('S (i).xlsx',y);
x_data2 = sprintf('S (%d).xlsx',j);
x_cal = xlsread(x_data2);
end
PS: I'm a beginner in MATLAB.
Thanks,

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

 采纳的回答

Walter Roberson
Walter Roberson 2017-6-18

2 个投票

for i = 1 : 58
filename = sprintf('S (%d).xlsx',i);
data = xlsread(filename);
if mod(i, 2) == 1
x_cal_odd{ (i + 1) / 2 } = data;
else
x_call_even{i / 2 } = data;
end
end

2 个评论
显示 无 隐藏 无

Thanks Walter, it your code is working perfectly.
now I have 2 cells with size of 1x29, how can I add all of the 29 columns in one cell together and make a nx156 data file? ( the size of each is 720x156 , so I guess it will be 13680x156) I want to give this to neural network.
Walter Roberson
Walter Roberson 2017-6-20
BigMatrix{1} = cell2mat( FirstCell(:) );
BigMatrix{2} = cell2mat( SecondCell(:) );
Note: 29 by 720 is 20880 not 13680: 13680 would be what you would get for 19 by 720

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by