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

Question

Tian Tian 2017-8-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354797-open-image-in-a-folder-and-save-outputted-data-in-excel-with-the-same-name-as-image

评论： Tian Tian 2017-9-15

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.

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

请先登录，再进行评论。

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

Answer 1

KSSV 2017-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354797-open-image-in-a-folder-and-save-outputted-data-in-excel-with-the-same-name-as-image#answer_279914

在 MATLAB Online 中打开

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Tian Tian 2017-9-1

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 2017-9-15