How to save all data from a loop in excel?

2 次查看(过去 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 个评论
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 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by