.mat to .excel

5 views (last 30 days)
Kiara Xhindi
Kiara Xhindi on 31 May 2021
Answered: Walter Roberson on 1 Jun 2021
Hello I was using this workflow to convert the .mat file to excel file
load('Filename.mat')
csvwrite ('NewfileX.csv', File00X);
So my initial matrix is composed of 90 matrixes and I was wondering how to automate this process so that the loop does each matrix one by one. I was trying to make the X value change each loop but it doesn't work.

Answers (1)

Walter Roberson
Walter Roberson on 1 Jun 2021
filestruct = load('filename.mat');
fields = fieldnames(filestruct);
for K = 1 : length(fields)
thisfield = fields{K};
outfilename = sprintf('New_%s.csv', thisfield);
csvwrite(outfilename), filestruct.(thisfield));
end
This will write each variable inside of filename.mat as a separate csv file that is named "New_" followed by the name of the variable.

Community Treasure Hunt

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

Start Hunting!