loop iteration of table in excel

12 vues (au cours des 30 derniers jours)
Hashvi Sai
Hashvi Sai le 27 Juil 2021
Commenté : Peter Perkins le 28 Juil 2021
Im new to matlab.
I have a complex program of EEG data analysis. i get 6 outputs, each of which needs to be written in a different sheet in excel, without erasing the previous. which is the best suitable function? can someone pls help me with the code

Réponses (2)

Albert Bing
Albert Bing le 27 Juil 2021
xlswrite(filename, Data, sheet)
A = randn(4,3,6);
filename = 'test.xlsx';
for i=1:6
xlswrite(filename, A(:,:,i), i);
  1 commentaire
Peter Perkins
Peter Perkins le 28 Juil 2021
xlsread and xlswrite are NOT recommended any more. readtable/writetable or readmatrix/writematrix are the way to go.

Connectez-vous pour commenter.

Dave B
Dave B le 27 Juil 2021
How about writetable? It has a 'Sheet' option:
  2 commentaires
Dave B
Dave B le 28 Juil 2021
Hashvi :
The writetable documentation page has an example with appending, I looks like it's as easy as specifying 'WriteMode', 'append' with the command but I haven't tried it. You can also write directly to a specific range. writetable has lots of options and a great documentation page with several examples, I recommend having a look !
(Alternatively, you could read, append, and write the whole thing, or you could try the xlsappend file exchange submission which looks quite popular)
Best ,

Connectez-vous pour commenter.


En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange


Community Treasure Hunt

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

Start Hunting!

Translated by