How can I input all the results using xlswrite for each loop?

Question

Braiki Marwa 2017-8-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/351966-how-can-i-input-all-the-results-using-xlswrite-for-each-loop

编辑： Braiki Marwa 2017-8-10

When I run the following code:

for i=1:3

   for niter=1:2  
        img_filtree=smooth_diffusion(I,edgestop(i),'dir',5,niter,0.25);
%       figure(1),imshow(img_filtree);
%       saveas(figure(1), strcat('Résultats\','img_filtree',num2str(niter),'_edgestop',num2str(i),'.tif'));
        imwrite(img_filtree,strcat('Résultats\','img_filtree_',num2str(niter),'-edgestop',num2str(i),'.tif'));%   
        peaksnr{i,niter}=psnr(img_filtree,Isynth)
        snr{i,niter}=psnr(img_filtree,Isynth)
%       [peaksnr,snr] = psnr(img_filtree,Isynth)
        Ed=edge(img_filtree); 
%       F= pratt(Ea,Ed);
        F{i,niter}= pratt(Ea,Ed) 
        filename = 'testdata.xlsx';
        A = {'PSNR','SNR','FOM'; peaksnr{i,niter}, snr{i,niter},F{i,niter}};
%       sheet = 2;
        xlRange = 'A1';
%       xlswrite(filename,A,sheet,xlRange)
        xlswrite(filename,A,xlRange)
   end
end

I got just the final result

2 个评论
显示无隐藏无

Bastien Dietemann 2017-8-8

在 MATLAB Online 中打开

I hope to get your question right. You want to save your results in an excel sheet and you are concerned that your results get overwritten each time, correct? If this is the case and you do not care about the layout, you could simply predefine the cells in which you results are saved in. Put

mycells = {'A1','E1','I1';'A4','E4','I4'};

before the loops and then instead of xlRange = 'A1' you write

xlRange=mycells{niter,i};

Does this solve your problem?

Braiki Marwa 2017-8-8

编辑：Braiki Marwa 2017-8-8

在 MATLAB Online 中打开

Thanks Bastien Dietemann for your reply but this solotion can't solve the problem

mycells = {'A1','E1','I1';'A4','E4','I4'};
for i=1:3
 for niter=1:2
        img_filtree=smooth_diffusion(I,edgestop(i),'dir',5,niter,0.25);
%       figure(1),imshow(img_filtree);
%       saveas(figure(1), strcat('RÃ&copy;sultats\','img_filtree',num2str(niter),'_edgestop',num2str(i),'.tif'));
        imwrite(img_filtree,strcat('RÃ&copy;sultats\','img_filtree_',num2str(niter),'-edgestop',num2str(i),'.tif'));%   [peaksnr1,snr1] = psnr(img_filtree1,Isynth)
        peaksnr{i,niter}=psnr(img_filtree,Isynth)
        snr{i,niter}=psnr(img_filtree,Isynth)
        Ed=edge(img_filtree); 
        F{i,niter}= pratt(Ea,Ed)
        filename = 'testdata.xlsx';
        A = {'PSNR','SNR','FOM'; peaksnr, snr,F};
%         sheet = 2;
        xlRange=mycells{niter,i};
%         xlRange = 'A1';
%         xlswrite(filename,A,sheet,xlRange)
        xlswrite(filename,A,xlRange)
   end
end
I want a table like this:

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Bastien Dietemann 2017-8-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/351966-how-can-i-input-all-the-results-using-xlswrite-for-each-loop#answer_277385

编辑：Bastien Dietemann 2017-8-9

在 MATLAB Online 中打开

Okay, let's have another try. I don't have your functions so I cannot test your Version, but this should work.

filename = 'testdata.xlsx';
xlswrite(filename,{'iteration'},1,'A2');
xlswrite(filename,{'edgestop1'},1,'C1');
xlswrite(filename,{'edgestop2'},1,'F1');
xlswrite(filename,{'edgestop3'},1,'I2');
xlswrite(filename,{'PSNR' 'SNR' 'FOM'},'B2:D2');
xlswrite(filename,{'PSNR' 'SNR' 'FOM'},'E2:G2');
xlswrite(filename,{'PSNR' 'SNR' 'FOM'},'H2:J2');
max_niter = 2;
%create destinations
mycells=cell(max_niter,3);
for i =1:max_niter
  mycells{i,1}=sprintf('B%i:D%i',i+2,i+2);
  mycells{i,2}=sprintf('E%i:G%i',i+2,i+2);
  mycells{i,3}=sprintf('H%i:J%i',i+2,i+2);
end
for i=1:3
for niter=1:max_niter
      img_filtree=smooth_diffusion(I,edgestop(i),'dir',5,niter,0.25);
%       figure(1),imshow(img_filtree);
%       saveas(figure(1), strcat('RÃ&copy;sultats\','img_filtree',num2str(niter),'_edgestop',num2str(i),'.tif'));
      imwrite(img_filtree,strcat('RÃ&copy;sultats\','img_filtree_',num2str(niter),'-edgestop',num2str(i),'.tif'));%   [peaksnr1,snr1] = psnr(img_filtree1,Isynth)
      peaksnr{i,niter}=psnr(img_filtree,Isynth);
      snr{i,niter}=psnr(img_filtree,Isynth);
      Ed=edge(img_filtree); 
      F{i,niter}= pratt(Ea,Ed);
      A = {peaksnr, snr,F{i,niter}};
      xlRange=mycells{niter,i};
      xlswrite(filename,A,xlRange)
 end
end

2 个评论
显示无隐藏无

José-Luis 2017-8-9

If performance is an issue (and it will be if you call xlswrite repeatedly), it might be better to use ActiveX controls.

Braiki Marwa 2017-8-10

编辑：Braiki Marwa 2017-8-10

Dear Bastien Dietemann, I try your solution, it gives me this result :

I change A = {peaksnr, snr,F{i,niter}}; by A = {peaksnr{i,niter}, snr{i,niter},F{i,niter}}; it gives me this result :

But there are still two problems with this code:

1) edgestop3

2) The number of iteration

请先登录，再进行评论。

How can I input all the results using xlswrite for each loop?

2 个评论
显示无隐藏无

回答（1 个）

2 个评论
显示无隐藏无

另请参阅

类别

标签

Community Treasure Hunt

How can I input all the results using xlswrite for each loop?

2 个评论 显示 无隐藏 无

回答（1 个）

2 个评论 显示 无隐藏 无

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

2 个评论
显示无隐藏无