Save variable from struct to excel file

2 views (last 30 days)
Hello,
I have this data.mat file with "errors" and "distractors" variables for 27 participants in three different conditions. I would like to export error data for each participant filtered by condition to three different excel files (one per condition). I am pretty new to Matlab so I am having some difficulties doing this, anyone could advice how to do it?
Thanks in advance,
Mikel
  1 Comment
Mikel  Jimenez
Mikel Jimenez on 2 Dec 2021
I'm trying with:
f=vertcat(data.errors{:,2});
T = array2table(f);
writetable(T,'Name.xls');
but I think I need to include a loop, any ideas?
Thanks,
Mikel

Sign in to comment.

Accepted Answer

Ive J
Ive J on 2 Dec 2021
You have 3 conditions: each row in 'errors' corresponds to each condition. However, each row in 'distractors' is another matrix of 3X200. You may want to modify this snippet a bit depending on your need.
errors = horzcat(data.errors);
distractors = horzcat(data.distractors);
for i = 1:3
file = "data.cond." + i + ".xlsx";
er = cell2mat(errors(i, :).');
di = cell2mat(distractors(i, :).');
writematrix(er, file, 'Sheet', 'errors')
writematrix(di, file, 'Sheet', 'distractors')
end

More Answers (0)

Categories

Find more on Structures in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!