using cat for a sequence of files

2 visualizzazioni (ultimi 30 giorni)
antonet
antonet il 29 Mag 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

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 29 Mag 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 Commenti
Oleg Komarov
Oleg Komarov il 29 Mag 2012
[data,text,all] = xlsread()
Check out the third output of xlsread.
antonet
antonet il 30 Mag 2012
thank you oleg

Accedi per commentare.

Più risposte (0)

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by