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

8 views (last 30 days)
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.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 18 Apr 2019
Edited: MathWorks Support Team on 18 Apr 2019
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>

More Answers (0)

Tags

No tags entered yet.

Products


Release

R2006a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!