B&W Image to Excel File with 0 and 1

2 次查看（过去 30 天）
Sam Schiavitti
Sam Schiavitti 2021-9-9
评论： 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.

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

采纳的回答

Walter Roberson
Walter Roberson 2021-9-10
编辑：Walter Roberson 2021-9-10
YourImage = imread('TheFileNameGoesHere.jpg');
if ndims(YourImage) > 2; YourImage = rgb2gray(YourImage); end
BW = imbinarize(YourImage);
writematrix(double(BW), 'NameOfExcelFileGoesHere.xlsx')
  4 个评论
显示 2更早的评论
Sam Schiavitti
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?

请先登录，再进行评论。

更多回答（1 个）

Dyuman Joshi
Dyuman Joshi 2021-9-10
编辑：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
Walter Roberson 2021-9-10
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
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).

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by