Write value to excel
3 views (last 30 days)
Show older comments
Hilbrand Swieringa
on 22 Sep 2015
Edited: Hilbrand Swieringa
on 22 Sep 2015
Hello Everybody,
Due an internship assignment i'm using matlab. I haven't got many experience with it. My question is;
This is part of my code that i'm trying to get work. The meaning is to set a batch of images to grayscale and then crop at the given coördinates. After that i need to get the information of the average gray value and write that to excel. I can do it for one image, but i need to get a table with the information. the first value need to be written in 'B2' the next one in 'B3' the 3rd one in 'b4' etc.
Can someone help me with it?
Kind regards
Hilbrand
0 Comments
Accepted Answer
Thorsten
on 22 Sep 2015
You should compute the mean gray values of all images in the for loop as follows
B2(i) = mean2(I1);
B3(i) = mean2(I2);
B4(i) = mean2(I3);
Outside the for loop you then write the three B vectors to their specific sheets
xlswrite(filenamexlsx,B2,'B2');
xlswrite(filenamexlsx,B3,'B3');
xlswrite(filenamexlsx,B4,'B4');
More Answers (1)
Walter Roberson
on 22 Sep 2015
Save all of the values in a cell array. At the end of the loop write out the cell array
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!