清空筛选条件
清空筛选条件

Write value to excel

3 次查看（过去 30 天）
Hilbrand Swieringa
Hilbrand Swieringa 2015-9-22
编辑： Hilbrand Swieringa 2015-9-22
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

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

采纳的回答

Thorsten
Thorsten 2015-9-22
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');
  3 个评论
显示 1更早的评论
Thorsten
Thorsten 2015-9-22
编辑：Thorsten 2015-9-22
This makes more sense. So in the for loop, use
data(i,:) = [mean2(I1) mean2(I2) mean2(I3)];
And outside the loop write the data to the xls file
xlswrite(filenamexlsx,data);
Hilbrand Swieringa
Hilbrand Swieringa 2015-9-22
I think I found the sollution! It seems to work right now for this part!!
Thank you for your help! :)

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2015-9-22
Save all of the values in a cell array. At the end of the loop write out the cell array

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by