Exporting string data from a structure array to a cell in Excel worksheet .
1 次查看(过去 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 中查找有关 Audio and Video Data 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!