How can I export MATLAB figures to Excel using Excel Link?

I have a MATLAB file which creates 26 figures. I would like to copy these figures as a group into an Excel file. Currently I copy and paste manually.

Answer 1

[MathWorks Support Team]

This feature has been incorporated into Excel Link 2.4 (R2006b). There is a new function called MLGetFigure which copies MATLAB figures into Excel. For more information execute the following command at the MATLAB prompt.

doc MLGetFigure

You can also do this by launching Excel from MATLAB by using the ActiveX Automation client feature of MATLAB. You can print a figure to the clipboard and then insert the clipboard contents into Excel. One example of this type of functionality is the SAVEPPT function on MATLAB Central File Exchange which inserts figures into PowerPoint. For information about the Excel ActiveX Automation interface please consult the Excel documentation.

For more information about using MATLAB as an Automation client see the following link:

https://<https://in.mathworks.com/help/matlab/matlab_external/matlab-com-automation-server-interface.html www.mathworks.com/help/matlab/matlab_external/matlab-com-automation-server-interface.html>