How to save all data from a loop in excel?

2 Ansichten (letzte 30 Tage)
Ann G
Ann G am 28 Mär. 2016
Bearbeitet: MHN am 30 Mär. 2016
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?

Akzeptierte Antwort

MHN
MHN am 28 Mär. 2016
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 Kommentare
Ann G
Ann G am 30 Mär. 2016
Bearbeitet: Ann G am 30 Mär. 2016
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 am 30 Mär. 2016
Bearbeitet: MHN am 30 Mär. 2016
T = table(Mean, Skewness);
writetable(T,'myData.xls') % it will be saved in ur current directory

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by