open image in a folder and save outputted data in excel with the same name as image

Hi, I am trying to open images from a folder one by one and do processing, afterwards i hope to save output in an created excel with the same name as this image. My current code for opening image is:

for k=1:numel(files)
  fullFileName = fullfile(folder, files{k})
  cellArrayOfImages{k}=imread(fullFileName);
            afm = image(cellArrayOfImages{k});
excelfilename = fullfilename.xlsx;
writetable(T,excelfilename,'Sheet',1,'Range','A1')

end

Could anyone help me to point out the mistake and give me some ideas how to correct it? Thank you.

Answer 1

[KSSV]

folder = pwd ;  % give your path 
files = [folder filesep '*.jpg']  ;  % give extension of images 
files = dir(files) ; % get all image files in the folder

N = length(files) ; 
for k=1:N
    fullFileName = fullfile(folder, files(k).name) ;
    cellArrayOfImages=imread(fullFileName);
    afm = image(cellArrayOfImages);
    [pathstr,name,ext] = fileparts(fullFileName) ;
    excelfilename = strcat(pathstr,name,'.xlsx') ;

      writetable(T,excelfilename,'Sheet',1,'Range','A1')
  end

[Tian Tian]

Thanks a lot for your answer. If I continue to process this image before writing result in excel, is it possible to have an error ('Error using imageDisplayValidateParams Expected input number 1, I, to be one of these types:

numeric, logical

Instead its type was matlab.graphics.primitive.Image.'). Where I could correct? I think afm is an image right now? Thank you.

[Tian Tian]

Another thing is I couldn't find the created excel file. Is Matlab that supposed to create an excel file with the same name with image and store data there, right? Thanks.

[Tian Tian]

Thanks a lot!