loop iteration of table in excel

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

Answer 1

[Albert Bing]

xlswrite(filename, Data, sheet)

e.g.

A = randn(4,3,6);
filename = 'test.xlsx';
for i=1:6
    xlswrite(filename, A(:,:,i), i);
end

[Peter Perkins]

xlsread and xlswrite are NOT recommended any more. readtable/writetable or readmatrix/writematrix are the way to go.

Answer 2

[Dave B]

How about writetable? It has a 'Sheet' option:

t=readtable('patients');
t2=readtable('morePatients')
writetable(t,'foo.xls','Sheet',1)
writetable(t2,'foo.xls','Sheet',2)

[Hashvi Sai]

hi Dave

How do i append?

[Dave B]

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