Effacer les filtres
Effacer les filtres

Save variable from struct to excel file

4 vues (au cours des 30 derniers jours)
Mikel  Jimenez
Mikel Jimenez le 2 Déc 2021
Commenté : Mikel Jimenez le 5 Déc 2021
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 commentaire
Mikel  Jimenez
Mikel Jimenez le 2 Déc 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

Connectez-vous pour commenter.

Réponse acceptée

Ive J
Ive J le 2 Déc 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
  1 commentaire
Mikel  Jimenez
Mikel Jimenez le 5 Déc 2021
Fantastic, this works perfectly.
Thanks

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by