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

1 次查看（过去 30 天）
Tian Tian
Tian Tian 2017-8-31
评论： 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.

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

采纳的回答

KSSV
KSSV 2017-9-1
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更早的评论
Tian Tian
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Images 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by