Saving Table in Excel while in loop

1 view (last 30 days)
Hashvi Sai
Hashvi Sai on 28 Jul 2021
Edited: KSSV on 28 Jul 2021
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.

Accepted Answer

KSSV
KSSV on 28 Jul 2021
Edited: KSSV on 28 Jul 2021
Loop is not needed, you can striaght away write the matrix into excel.
writematrix(AllMI,'test.xlsx');

More Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!