How import matlab figure in Excel via VBA

Question

Massimo Laspia 2017-7-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/350468-how-import-matlab-figure-in-excel-via-vba

回答： 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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Selva Karna 2017-7-27

u can use xlswrite

请先登录，再进行评论。

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

Answer 1

Nirav Sharda 2017-8-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/350468-how-import-matlab-figure-in-excel-via-vba#answer_276507

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.