Exporting multiple Excel Files

Question

012786534 2017-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/344767-exporting-multiple-excel-files

回答： Akira Agata 2017-7-14

Hello all,

I have a folder with several text files. I am opening them and modifying them in a loop. My question is: how can I save each of them in an individual Excel file with the same name as the text file ?

Thank you

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

请先登录，再进行评论。

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

Answer 1

Akira Agata 2017-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/344767-exporting-multiple-excel-files#answer_274112

在 MATLAB Online 中打开

I think the MATLAB script for your question will be as follows:

fileList = dir('*.txt');
for kk = 1:numel(fileList)
    % Some process which generates numeric array
    ...
    % Save to excel file
    fileName = strrep(fileList(kk).name,'.txt','.xlsx');
    xlswrite(fileName, outputArray);
  end