To save plots without showing them on the screen

Hello.

The following code is supposed to plot a variable and save it in an EXCEL sheet. I am running a series of codes for biomechanical analysis of gait with about 500 plots that must be saved in one EXCEL sheet. It means for each sheet, I have to wait for a plot and save this plot in the EXCEL sheet. It is time taking and needs memory becasue MATLAB has to show 500 plots on the screen and save them in the EXCELL document!

figure;
for k=1:length(mN(:,1))
    plot(mN(k,:),'g')
    hold on
end
plot(mN,'b','linewidth',2)
title ('Healthy_Right');
writetable(table(ccc, ddd), 'Biomechanics_PT_Pre','WriteVariableNames', true);
xlswritefig(gcf, 'Biomechanics_PT_Pre', 'CV_BOSlenRRLL', 'B20');

Using %, I deactivated the plot command. However, MATLAB saved the plots in the EXCEL sheet without any curves!!! As an amateur, I asked MATLAB to close the plots (using the "close all" command) after saving the plot in the EXCEL sheet but I know it is not a good way. Is there any way to directly save the plots in the EXCEL document without showing them on the screen? Would you please assist me to improve the speed of this process? Please assist me with this issue.

Sincerely,

Answer 1

[Alberto Cuadra Lara]

Hi Vahid,

Just set the property 'visible' of the object figure to 'off'.

f = figure('visible','off');
hold on
for k=1:length(mN(:,1))
    plot(mN(k,:),'g')
end
plot(mN,'b','linewidth',2)
title ('Healthy_Right');
writetable(table(ccc, ddd), 'Biomechanics_PT_Pre','WriteVariableNames', true);
xlswritefig(gcf, 'Biomechanics_PT_Pre', 'CV_BOSlenRRLL', 'B20');

[Vahid Esmaeili]

Hello Alberto,

Thank you so much for the reply. It is working now. However, when I ask MATLAB to add some calculations to the same EXCEL sheet, it saves them in another EXCEL sheet with the same name!

f = figure('visible','off');
for k=1:length(mP(:,1))
    plot(mP(k,:),'g')
    hold on
end
plot(mP,'r','linewidth',2)
title ('Right_PT_Pre');

writetable(table(ccc, ddd), 'Biomechanics_PT_Pre','WriteVariableNames', true);
xlswritefig(gcf, 'Biomechanics_PT_Pre', 'CV_BOSlenRLLR', 'N20');
xlswrite('Biomechanics_PT_Pre',alpha_adjust,'CV_BOSlenRLLR','A150')
xlswrite('Biomechanics_PT_Pre',alpha_bonf,'CV_BOSlenRLLR','A152')
xlswrite('Biomechanics_PT_Pre',logALPHA_adj,'CV_BOSlenRLLR','A154')

MATLAB saved the plots in an EXCEL sheet named "Biomechanics_PT_Pre.xlsx" and saved the last 3 lines in another EXCEL sheet named"Biomechanics_PT_Pre.xls" while I wanted the figures and the volumes of the variables in the last 3 lines in the same EXCEL sheet.

It is appreciated if you assist me to find a solution for this issue as well.

Vahid,

[Alberto Cuadra Lara]

Hi Vahid,

You are not using the same function. "xlswrite" is not recommended. Use writetable as in the first case. Btw, "xlswritefig" is a function you created, right?

[Vahid Esmaeili]

Hello Alberto,

Thank you for the reply. I will try writetable and I will inform you how it works.

I found the "xlswritefig" on MathWorks.