How import matlab figure in Excel via VBA

4 次查看（过去 30 天）
Massimo Laspia
Massimo Laspia 2017-7-27
回答： Massimo Laspia 2017-8-3
Hi, I need to import Matlab figures, generated by a code, into Excel. I'd like to do this via VBA. MLGetFigure permits to import the current figure but in matlab I created 4-5 figure. Which command should I use in VBA?
Thanks
Massimo

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

回答（2 个）

Nirav Sharda
Nirav Sharda 2017-8-2
There are multiple ways to do this. You can save the MATLAB figures as .jpg files and import them in Excel. You can also use the ActiveX Automation client feature of MATLAB and start Excel, then print the figure to clipboard and then insert the clipboard contents in Excel as mentioned in the following MATLAB Answers post.
https://www.mathworks.com/matlabcentral/answers/98976-how-can-i-export-matlab-figures-to-excel-using-excel-link
I hope this helps.
Massimo Laspia
Massimo Laspia 2017-8-3
thanks

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by