Exporting multiple Excel Files

1 次查看（过去 30 天）
012786534
012786534 2017-6-14
回答： 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

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

回答（1 个）

Akira Agata
Akira Agata 2017-7-14
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by