open image in a folder and save outputted data in excel with the same name as image
2 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
KSSV
on 1 Sep 2017
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 Comments
More Answers (0)
See Also
Categories
Find more on Data Export to MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!