Info

此问题已关闭。 请重新打开它进行编辑或回答。

How can I import multiple Excel files?

2 次查看（过去 30 天）
Asher Zaidi
Asher Zaidi 2018-6-6
关闭： Asher Zaidi 2018-6-6
files = dir('*.xls');
for i=1:length(files)
x = eval(['importdata(files(i).name)']);
z1 = x.data(:,5); %grabs column 5 from x.data
z2 = x.data(:,6); %grabs column 6 from x.data
%%obtains value closest to 0 in column 'z2'
numb=0;
[~, imin] = min(abs(z2 - numb));
value(i) = z2(imin)
plot(z1,z2)
end
When trying to run the code above, I get this error
>> test2
Warning: File contains uninterpretable data.
> In importdata (line 144)
In test2 (line 3)
Index in position 2 exceeds array bounds.
Error in test2 (line 4)
z1 = x.data(:,5); %grabs column 5 from x.data
However, if I attempt to import ".txt" files it works just fine. How can I import multiple excel files?
  4 个评论
显示 2更早的评论
Asher Zaidi
Asher Zaidi 2018-6-6
xlsread('1.xlsx')
Error using xlsread (line 260)
Invalid zip file "/MATLAB Drive/1.xlsx".
'xlsread()' gives this error above
Asher Zaidi
Asher Zaidi 2018-6-6
I can confirm, after saving the file as an "Excel 97-2003 Workbook" (.xls), it began working fine. Thank you!

此问题已关闭。

回答（0 个）

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by