B&W Image to Excel File with 0 and 1

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.

Answer 1

[Walter Roberson]

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

[Sam Schiavitti]

thank you, is there anyway to make the excel file smaller, like so its not 600 variables by 600 variables. like rather 60 by 60 or something like that

[Walter Roberson]

BW = imresize(BW, [60 60]);

[Sam Schiavitti]

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]

~BW

Answer 2

[Dyuman Joshi]

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).

[Walter Roberson]

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]

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).