Azzera filtri
Azzera filtri

loop iteration of table in excel

10 visualizzazioni (ultimi 30 giorni)
Hashvi Sai
Hashvi Sai il 27 Lug 2021
Commentato: Peter Perkins il 28 Lug 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

Risposte (2)

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

Accedi per commentare.

Dave B
Dave B il 27 Lug 2021
How about writetable? It has a 'Sheet' option:
  2 Commenti
Hashvi Sai
Hashvi Sai il 28 Lug 2021
hi Dave
How do i append?
Dave B
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 ,

Accedi per commentare.


Community Treasure Hunt

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

Start Hunting!

Translated by