MATLAB Answers

how can i read 20 files form excel for matlab together

1 view (last 30 days)
sabah
sabah on 25 Feb 2015
Edited: Sad Grad Student on 25 Feb 2015
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

Answers (2)


Sad Grad Student
Sad Grad Student on 25 Feb 2015
Edited: Sad Grad Student on 25 Feb 2015
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!