Saving Table in Excel while in loop

Hi All

Im running a program pertaining to EEG data. I have a table with one row and while the loop is running i want the output to be saves in excel. i used the following code.

filename = 'testdata.xls'

 for n=1:2
     AllMI(1:1,:)
    writetable(AllMI,'testdata.xls','Sheet',1,'Range', ['A' num2str(n)],'WriteVariableNames',false)
end

the problem is that both the rows are showing the same output.

Please help me with this.

Answer 1

[KSSV]

Loop is not needed, you can striaght away write the matrix into excel.

writematrix(AllMI,'test.xlsx');