How to save all data from a loop in excel?

12 views (last 30 days)
Ann G
Ann G on 28 Mar 2016
Edited: MHN on 30 Mar 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?

Accepted Answer

MHN
MHN on 28 Mar 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 Comments
MHN
MHN on 30 Mar 2016
T = table(Mean, Skewness);
writetable(T,'myData.xls') % it will be saved in ur current directory

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by