How to merge excel files?
2 次查看(过去 30 天)
显示 更早的评论
I have 4 excel files. Each excel file contains 5 sheets (Sheet1, Sheet2, Sheet3, Sheet4 and Sheet5). Each sheet contains different number of rows.
I want to merge all the excel files into one excel file containing 5 sheets. Content of sheet1 of all the 4 excel files should merge into sheet1 of the new excel file. Similarly content of sheet2 of all the 4 excel files should merge into sheet2 of the new excel file. Same is the case with rest of sheets of the 4 excel file.
Also all the sheet of all 4 excel files contains a header row. But in final output excel file I want only one header row per sheet.
Please tell me how this can be done
Thanks in advance
0 个评论
采纳的回答
Yona
2016-2-15
This code will work, If you have the same number of column in the same sheets (all sheet1s have the same columns number, ext.)
res = cell(1,5); %sheets number
for i=1:4 %file number
if exist(strcat(FilePath,filesep,'file_name', num2str(i),'.xlsx'),'file')
for j=1:5 %sheets number
[~, ~, HelpCell] = xlsread(strcat(FilePath,filesep,'file_name', num2str(i),'.xlsx'),strcat('sheet', num2str(j));
if isempty(HSrejectC)
res{j} = HelpCell;
else
res{j} = [res{j}; HelpCell(2:end,:)];
end
end
end
end
after this you need to save res to 5 sheets by using xslwrite.
更多回答(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!