using cat for a sequence of files

4 views (last 30 days)
antonet
antonet on 29 May 2012
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

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 29 May 2012
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{:});
  3 Comments

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by