Saving Table in Excel while in loop

2 次查看（过去 30 天）
Hashvi Sai
Hashvi Sai 2021-7-28
编辑： KSSV 2021-7-28
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.

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2021-7-28
编辑：KSSV 2021-7-28
Loop is not needed, you can striaght away write the matrix into excel.
writematrix(AllMI,'test.xlsx');

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by