How to save all data from a loop in excel?

1 次查看（过去 30 天）
Ann G
Ann G 2016-3-28
编辑： MHN 2016-3-30
I calculate statistical values like Entropy, Energy, Mean etc from a 3D image..So I use a loop to go through all slices of the image and calculate the values..How can I save the values of all the slices in excel in different columns each time?

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

采纳的回答

MHN
MHN 2016-3-28
Instead of writing each column in an excel file (which takes a lot of time, since each time you should get access to memory) it is better to save your result in a variable (it might be easier to use a table structure) and save that variable in an excel file finally. then you can easily write that variable in an excel file:
xlswrite('test.xlsx', variable)
  3 个评论
显示 1更早的评论
Ann G
Ann G 2016-3-30
编辑：Ann G 2016-3-30
To be more specific: I calculate the mean and the skewness for 4 slices..
flag=0;
for i=1:4
flag=flag+1;
Mean(flag)=mean(I);
Skewness(flag)=skewness(I);
end
MHN
MHN 2016-3-30
编辑：MHN 2016-3-30
T = table(Mean, Skewness);
writetable(T,'myData.xls') % it will be saved in ur current directory

请先登录，再进行评论。

更多回答（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