using cat for a sequence of files

1 次查看（过去 30 天）

antonet 2012-5-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39692-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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov 2012-5-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39692-using-cat-for-a-sequence-of-files#answer_49337

在 MATLAB Online 中打开

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{:});