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 1×360 data. I want to read test.xls and export to file result.xls. result.xls is 15000×360 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
endendxlswrite( 'E:/result.xlsx', results );
Best Answer