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);

채택된 답변

Walter Roberson
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 CenterFile Exchange에서 String Parsing에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by