How to extract pixel intensity of a grayscale image (*.jpg) to a MS Excel table
12 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Sameer
le 16 Sep 2024
Modifié(e) : Sameer
le 16 Sep 2024
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');
Please refer to the below MathWorks documentation link:
Hope this helps!
3 commentaires
Plus de réponses (1)
Image Analyst
le 16 Sep 2024
See my attached demo that writes an image out to a CSV text file that can be read in by Excel.
Voir également
Catégories
En savoir plus sur Import, Export, and Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!