Merge excel files to one with many sheets csv

2 次查看（过去 30 天）

Adrian Pielmeier 2018-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428495-merge-excel-files-to-one-with-many-sheets-csv

评论： Guillaume 2018-11-7

Hi to all,

i would like to select a directory with a few excel csv files. And these csv files with its strings and numbers i would like to have in one excel csv. Every file gets one sheet. And the sheet name should be the excel file name it was before the merge.

So how can i do this the best? I have the MATLAB R2016b version.

Many thanks

Adrian

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Guillaume 2018-11-7

csv files (which are not excel files but that by default are opened in excel if it's installed) are just plain text files. As a result, they do not have a concept of sheet.

What you want can only be done if the output is a xls or xslx file (or equivalent spreadsheet format of other programs).

请先登录，再进行评论。

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