Write value to excel

N/A
2015 9 22
2 个回答
回答已采纳
更新时间：2015 9 22
1 次查看（30 天）

0 个投票

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

1 个投票

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更早的评论 隐藏 1更早的评论

N/A
N/A 2015-9-22
Hello,
when i use this code i get the following error: " Subscript indices must either be real positive integers or logicals."
when i dont use the (i) the info get on different sheets.
The meaning is to get a table in one sheet with all the gray values.
so for image 1 I1 the gray value in B2, image 2 I1 the gray value in b3 image 3 I1 the gray value in b4 -- and so for image 1 I2 the gray value in C2 image 2 I2 the gray value in C3 image 3 I2 the gray value in C4 ETC
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);
N/A
N/A 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

0 个投票

Save all of the values in a cell array. At the end of the loop write out the cell array

类别

在 帮助中心 和 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