how can i read 20 files form excel for matlab together

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

Answer 1

[dpb]

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Answer 2

[Sad Grad Student]

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