Exporting multiple Excel Files

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

Answer 1

[Akira Agata]

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