using cat for a sequence of files

suppose that I have some excel files(more than 2, actually 12). How can i use the command ' cat ' in a loop? I want to place one excel file below the other

I am looking something like:

clear all;

fname = {'dataoutput1.xlsx','dataoutput2.xlsx','dataoutput3.xlsx','dataoutput4.xlsx'};

for i=1:length(fname)

 a = xlsread(fname{i})
lo=cat(length(fname), a(i,:))
end

Does it matter if the files have different dimensions?

thank

Answer 1

[Andrei Bobrov]

about function cat

fname = {'dataoutput1.xlsx','dataoutput2.xlsx','dataoutput3.xlsx','dataoutput4.xlsx'};
a = cellfun(@xlsread,fname,'un',0);
[m,n] = cellfun(@size,a);
mm = max(m);
mn = max(n);
out1 = arrayfun(@(x,y,z)[x{:},nan(y,mn-z)],a,m,n,'un',0);
out1 = cat(1,out1{:});
out2 = arrayfun(@(x,y,z)[x{:};nan(mm-y,z)],a,m,n,'un',0);
out2 = cat(2,out2{:});

[antonet]

thanks it works fine.

the problem though is that the excel files contain sting variales as well. These variable appear as NaN in the out1 ot out2. Is it possible to avoid having this problem?

thanks

[Oleg Komarov]

[data,text,all] = xlsread()

Check out the third output of xlsread.

[antonet]

thank you oleg