loop iteration of table in excel

2 次查看（过去 30 天）
Hashvi Sai
Hashvi Sai 2021-7-27
评论： Peter Perkins 2021-7-28
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

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

回答（2 个）

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

请先登录，再进行评论。

Dave B
Dave B 2021-7-27
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)
  2 个评论
Dave B
Dave B 2021-7-28
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

请先登录，再进行评论。

类别

在 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