How to extract pixel intensity of a grayscale image (*.jpg) to a MS Excel table

Question

Mac 2024-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2153055-how-to-extract-pixel-intensity-of-a-grayscale-image-jpg-to-a-ms-excel-table

评论： Mac 2024-9-16

Hello everyone, I am a very new beginner with image processing and Mathlab. Please help me with the following isse, many thanks in advance !

I have a grayscale image. I'd like to extract its pixel intensities to a MS Excel table with three vectors, including pixel intensiy, X and Y coordinates of the pixel.

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

请先登录，再进行评论。

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

Answer 1

Sameer 2024-9-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2153055-how-to-extract-pixel-intensity-of-a-grayscale-image-jpg-to-a-ms-excel-table#answer_1517310

编辑：Sameer 2024-9-16

在 MATLAB Online 中打开

Hi Mac

From my understanding, you want to extract pixel intensities from a grayscale image and save them in an 'MS Excel' table with the corresponding X and Y coordinates.

Here’s how you can achieve it:

1. Read the Image: First, ensure your grayscale image is accessible, either in the current directory or by providing the full path.

% Read the grayscale image
img = imread('your_image.jpg');

2. Extract Pixel Intensities and Coordinates: Loop through each pixel to gather intensity values and their coordinates.

% Get the size of the image
[rows, cols] = size(img);
% Initialize vectors for storing pixel data
pixelIntensity = [];
xCoordinates = [];
yCoordinates = [];
% Loop through each pixel
for x = 1:cols
    for y = 1:rows
        % Append data to vectors
        pixelIntensity = [pixelIntensity; img(y, x)];
        xCoordinates = [xCoordinates; x];
        yCoordinates = [yCoordinates; y];
    end
end

3. Write Data to Excel: Utilize "writetable" function to save the extracted data into an Excel file.

% Create a table from the vectors
dataTable = table(xCoordinates, yCoordinates, pixelIntensity, ...
'VariableNames', {'X', 'Y', 'Intensity'});
% Write the table to an Excel file
writetable(dataTable, 'pixel_data.xlsx');