Running a macro in excel from Matlab

1 次查看（过去 30 天）
David
David 2016-3-18
评论： Guilherme Brigagão 2019-8-6
I have found codes for running macros in excel from matlab, however, it is generic code. Could I see someone's example code for running a macro in excel from matlab. Below is the code I currently have.
xlsfile = 'First_gui.xlsx'; macro = 'Split_Cells';
xls_run_macro(xlsfile,macro);

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

回答（1 个）

Krishna Chaitanya Duggineni
One way to invoke an Excel macro from MATLAB is by launching Excel as a COM server from MATLAB using the 'actxserver' command.
See the example in the link below.
http://www.mathworks.com/help/releases/R2015b/matlab/matlab_external/using-a-matlab-application-as-an-automation-client.html

类别

在 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