Exporting multiple Excel Files

012786534

2017 6 14

1 个回答

6 次查看（30 天）

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

回答（1 个）

Akira Agata 2017-7-14

在 MATLAB Online 中打开

0 个投票

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