Info
Cette question est clôturée. Rouvrir pour modifier ou répondre.
How can I import multiple Excel files?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (0)
Cette question est clôturée.
Voir également
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!