Read from multiple excel files and write into single excel file
조회 수: 1 (최근 30일)
이전 댓글 표시
I'm trying to read multiple excel files and write into single excel file using this code
source_dir = 'C:\Users\Marwah Ababneh\Desktop\Thesis\Matlab\1\Final\Database\features2' ;%my file source dir
source_files = dir(fullfile(source_dir, '*.xls'));
data = cell(length(source_files),13);
for i = 1:length(source_files)
data = xlsread(fullfile(source_dir, source_files(i).name));
end
xlswrite('Features.xls',data);
It reads all file but it writes on the file only the last read excel file
also i used this
data =[ ];
for i = 1:length(source_files)
data =[data; xlsread(fullfile(source_dir, source_files(i).name))];
end
xlswrite('Features.xls',data);
and this keeps getting the error 'Dimensions of arrays being concatenated are not consistent.'
댓글 수: 0
답변 (1개)
Clayton Gotberg
2021년 4월 26일
편집: Clayton Gotberg
2021년 4월 26일
Your two solutions have errors because:
1) In the first one, you overwrite data in each loop, then ask it to save when it has finished looping. You need to either save all of the data (as you try to do in solution #2) or you need to write the new data each time you get it.
2) In the second one, the issue is probably that the number of columns in at least one of your excel files is different. That one's hard to troubleshoot without your data and the line the error appears on. To check this, try using this code block:
for i = 1:length(source_files)
test = size(xlsread(fullfile(source_dir, source_files(i).name)))
end
댓글 수: 1
Clayton Gotberg
2021년 4월 26일
Additionally, there are some compatibility concerns with xlsread and xlswrite, so you might look into using the readtable, readmatrix, writetable and writematrix functions.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!