Exporting string data from a structure array to a cell in Excel worksheet .
조회 수: 3 (최근 30일)
이전 댓글 표시
I have written a program for automatic scoring for some CAD images. The problem I am currently facing is I am not able to export the name of the image file and the corresponding score to the same Excel worksheet. I have attached my code below. Also the string data in 'f' is not being stored in a single cell. How to do that ?
% Grade Multiple Files at Once
clc;
clear all;
Dir = 'C:\Users\Sanchit\Desktop\IDETC - Copy\Models\Flange\2D';
% Read images from Images folder
files = dir(fullfile(Dir, '*.png'));
for j=1:length(files)
Img = imread(fullfile(Dir, files(j).name)); % Read images from folder
I(j)=Flangenew(Img); % Grade files in the folder
end
f=[files(:).name]'
xlswrite('results', I');
xlswrite('filenames',f);
댓글 수: 0
채택된 답변
Walter Roberson
2017년 5월 24일
% Grade Multiple Files at Once
Dir = 'C:\Users\Sanchit\Desktop\IDETC - Copy\Models\Flange\2D';
% Read images from Images folder
files = dir(fullfile(Dir, '*.png'));
nfiles = length(files);
I = cell(nfiles+1, 2);
I{1,1} = 'File Name'; %column headers
I{1,2} = 'Score';
for j = 1:nfiles
thisfile = files(j).name;
Img = imread(fullfile(Dir, thisfile)); % Read images from folder
I{j+1, 1} = thisfile;
I{j+1, 2} = Flangenew(Img); % Grade files in the folder
end
xlswrite('results', I);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 String Parsing에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!