read .xls file from multiple folder and export to result.xls

2 次查看（过去 30 天）
viet le
viet le 2016-9-5
评论： viet le 2016-9-5
I have folders (z ii zjj) with ii=1:100 and jj=1:150 and each folder contains 1 file excel test.xls, test.xls is 1x360 data. I want to read test.xls and export to file result.xls. result.xls is 15000x360 data (100*150=15000), test.xls at z 0z 0 is at column 1, test.xls at z 0z 1 is at column 2..... test.xls at z 100z 150 is at column 15000.
for ii = 0 : 100
for jj=1:150
source_dir = sprintf('E:/zzzz/z %dz %d',ii,jj);
data = xlsread( fullfile(source_dir, 'test.xlsx') );
results(jj, :) = data; %%%%I think wrong in hear
end
end
xlswrite( 'E:/result.xlsx', results );

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

采纳的回答

Walter Roberson
Walter Roberson 2016-9-5
results = zeros(500, 360);
for i = 1 : 500
source_dir = sprintf('D:\zzzz\z%d',i);
data = xlsread( fullfile(source_dir, 'test.xls') );
results(i, :) = data;
end
xlswrite( 'D:\result.xls', results );
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2016-9-5
K = 0;
for ii = 0 : 1
for jj=1:2
source_dir = sprintf('E:/zzzz/z %dz %d',ii,jj);
data = xlsread( fullfile(source_dir, 'test.xlsx') );
K = K + 1;
results(K, :) = data;
end
end
xlswrite( 'E:/result.xlsx', results );

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by