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

Question

MathWorks Support Team 2012-9-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/98976-how-can-i-export-matlab-figures-to-excel-using-excel-link

编辑： MathWorks Support Team 2019-4-18

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 2019-4-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/98976-how-can-i-export-matlab-figures-to-excel-using-excel-link#answer_108323

编辑：MathWorks Support Team 2019-4-18

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>