How to combine multiple sheet in an excel file in to a single sheey

Question

Srikant Sekar 2021-9-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1446174-how-to-combine-multiple-sheet-in-an-excel-file-in-to-a-single-sheey

评论： Ive J 2021-9-4

I have an excel file with multiple sheets. Each sheet has single column and 350-450 row data. Around 80-95 sheets were there.How to bring all the column in sheets in to a single sheet? i need the name of each sheet to come as header in the final compiled sheet.am a beginner. Plz do help.

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

请先登录，再进行评论。

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

Answer 1

Ive J 2021-9-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1446174-how-to-combine-multiple-sheet-in-an-excel-file-in-to-a-single-sheey#answer_780349

在 MATLAB Online 中打开

Follow this example:

file = "test.xlsx"; % replace your file name
names = sheetnames(file);
data = table;
for i = 1:numel(names)
    data.(names(i)) = readmatrix(file, 'Sheet', names(i));
end
writetable(data, 'merged.xlsx')

Note it works for your case: one numeric column per each data sheet.

2 个评论
显示无隐藏无

Srikant Sekar 2021-9-4

Thank you so much for helping . an error mesg is coming as :Undefined function or variable 'sheetname'."

Ive J 2021-9-4

在 MATLAB Online 中打开

Are you sure you type the correct function name? it's sheetnames. Aslo what version of MATLAB do you use? sheetnames was introduced in R2019b. In case your MATLAB is older, you can use actxserver :

exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open(fullfile(pwd,'test.xlsx'));
nSheets = exlFile.Sheets.Count;
names = strings(nSheets, 1);
for i = 1:nSheets
    names(i) = exlFile.Sheets.Item(i).Name; % sheet names
end
Quit(exl)
delete(exl)