Add a xlsx file as target to an image

Hi all, my goal is to find a way to merge a list of images in which i want to associate as a label a xlsx file (made by 2 columns of numerical values), is there any way to do this? Thanks in advance

[Gianluigi Mazzaglia]

the goal is to train a model which will learn what are the points associated to that images

[Image Analyst]

A small example would help explain this to us.

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Answer 1

[Saffan]

Hi Gianluigi,

I understand that you have an XLSX file for each image, with the file name being the same as the image file name. To associate each image with its relevant data, you can create a structure that includes the image file location and the coordinates data extracted from the corresponding XLSX file, as shown in the following code snippet:

% Get a list of image files
imageFiles = dir('Z:/images/*.jpg');
% Get a list of XLSX files
xlsxFiles = dir('Z:/data/*.xlsx');    

data = struct();  % Initialize the struct to store image location and coordinates

for i = 1:numel(imageFiles)
    imageLocation = fullfile(imageFiles(i).folder, imageFiles(i).name);
    xlsxLocation = fullfile(xlsxFiles(i).folder, xlsxFiles(i).name);
    
    coordinates = readmatrix(xlsxLocation);
    
    data(i).imageLocation = imageLocation;
    data(i).coordinates = coordinates;
end

You can also consider creating an image datastore to read the images and a custom datastore to read the coordinates from the associated XLSX files. This approach allows for efficient handling of large datasets. Please refer to the following documentation for more information:

https://www.mathworks.com/help/matlab/import_export/what-is-a-datastore.html

Hope this helps!