B&W Image to Excel File with 0 and 1

Question

Sam Schiavitti 2021-9-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1450039-b-w-image-to-excel-file-with-0-and-1

评论： Walter Roberson 2021-9-13

Hello, I want to take a B&W image and convert it to an excel file with 0 and 1. Essentially it will put the image into excel labeling all black areas as a 1 and all white areas as a 0 making the image in excel. I am not sure how'd I go about doing that.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-9-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1450039-b-w-image-to-excel-file-with-0-and-1#answer_784529

编辑：Walter Roberson 2021-9-10

在 MATLAB Online 中打开

YourImage = imread('TheFileNameGoesHere.jpg');
if ndims(YourImage) > 2; YourImage = rgb2gray(YourImage); end
BW = imbinarize(YourImage);
writematrix(double(BW), 'NameOfExcelFileGoesHere.xlsx')

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sam Schiavitti 2021-9-13

Thank you so much! I have one last question if you dont mind. But if I wanted to swap the 0's and 1's ot be vice versa how would I do that?

Walter Roberson 2021-9-13

~BW

请先登录，再进行评论。

Answer 2

Dyuman Joshi 2021-9-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1450039-b-w-image-to-excel-file-with-0-and-1#answer_784509

编辑：Dyuman Joshi 2021-9-10

1) Use imread to read the image. The values in the uint8 (default format) array will be from 0 to 255.

2) Divide the array by 255 to get values from 0 to 1.

3) The matrix will be 3D matrix, which you won't be able to convert to a excel file. Either you can reshape the matrix to a 2D matrix and then write or you can write three files/sheets as you wish (Sheets).

2 个评论
显示无隐藏无

Walter Roberson 2021-9-10

在 MATLAB Online 中打开

If the image is truly black and white, then the matrix will not be 3D.

However, it is common for grayscale images (especially jpeg) to be represented as RGB images that happen to have all three color planes the same.

Instead of worrying about 3D under the circumstances,

YourImage = imread(TheFileNameGoesHere);
if ndims(YourImage) > 2; YourImage = rgb2gray(YourImage); end

Now you can count on YourImage not being 3D.

Dyuman Joshi 2021-9-10

I was going to make that distinction in the answer initially, but I did not and linked the imread webpage (where the specifics related to this are mentioned) hoping that if OP might comment/ask again, I can reply with the reference.

Due to the 2nd point you mentioned, I presumed that the matrix will (most probably) be a 3D matrix. However, your answer here is more fitting in the general sense (as always).

请先登录，再进行评论。