loop iteration of table in excel
11 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi,
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
TIA
0 Commenti
Risposte (2)
Albert Bing
il 27 Lug 2021
xlswrite(filename, Data, sheet)
e.g.
A = randn(4,3,6);
filename = 'test.xlsx';
for i=1:6
xlswrite(filename, A(:,:,i), i);
end
1 Commento
Peter Perkins
il 28 Lug 2021
xlsread and xlswrite are NOT recommended any more. readtable/writetable or readmatrix/writematrix are the way to go.
Dave B
il 27 Lug 2021
t=readtable('patients');
t2=readtable('morePatients')
writetable(t,'foo.xls','Sheet',1)
writetable(t2,'foo.xls','Sheet',2)
2 Commenti
Dave B
il 28 Lug 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 ,
Dave
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!