How to plot 16x16 pixel image from RGB data available in Excel Sheet?
显示 更早的评论
Hello, i have R,G,B data in excel sheet for each pixel in 16x16 array. I want to generate a 16x16 image using that data. The image must be 16x16 pixels only.
Thanks,
采纳的回答
Jakob Sørensen
2014-2-19
If I understand correctly, each sheet has the red (R) value in the first column, the green (G) value in the second and the blue (B) value in the third column. So with a 16x16 image, there should be 3 columns and 16 rows, in 16 sheets. Is that correct?
The function xlsread() can read one sheet at a time, making it possible to do a simple loop going through all the sheets, converting each one to a column.
% Make empty array for the image, this makes Matlab work a bit faster
img = zeros(16,16,3);
% Use a for loop to read each sheet, and insert it into a column in the image
for column = 1:16
img(:, column, :) = xlsread('NAME_OF_EXCEL_FILE.xlsx', column);
end
% Depending on the format of your data, you might have to convert to uint8
img = uint8(img);
I think that should do the trick, but without having your data, it is hard to test. Good luck with it :-)
2 个评论
Syed Haider
2014-2-19
Image Analyst
2014-2-19
Or better yet, use ActiveX and do it in 1/16th of the time.
更多回答（2 个）
Image Analyst
2014-2-18
1 个投票
Put it into the array using for loop. Not sure what you mean by plot, but if you want to plot you can use plot(). If you want to display as an image you can use imshow().
Jakob Sørensen
2014-2-18
0 个投票
Have a look at this artcile, regarding import from a worksheet. How to turn it into an image depends a bit on how your data is arranged.
类别
在 帮助中心 和 File Exchange 中查找有关 Convert Image Type 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
