open image in a folder and save outputted data in excel with the same name as image
조회 수: 1 (최근 30일)
이전 댓글 표시
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
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Export to MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!