Info

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

how can i read 20 files form excel for matlab together

1 次查看(过去 30 天)
i have code for read one file [a,b,c]=xlsread('myfile.xlsx') save myfile c ;its work but i want read 20 files together in one file where every file have 500*2 data

回答(2 个)

dpb
dpb 2015-2-25

Sad Grad Student
Sad Grad Student 2015-2-25
编辑:Sad Grad Student 2015-2-25
cd to the directory containing all files
allfiles = dir; allfiles(1:2) = []; %this is because allfiles(1) = . & allfiles(2) = ..
open a new file in write mode say foo
loop through allfiles like:
for i = 1:20
f = xlsread(allfiles(i).name)
append contents of f to foo using xlswrite
end

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by