Running a macro in excel from Matlab

조회 수: 4 (최근 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
Krishna Chaitanya Duggineni 2016년 3월 23일
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
  댓글 수: 1
Guilherme Brigagão
Guilherme Brigagão 2019년 8월 6일
Hey! Can you copy the answer here? I can't see this link..

댓글을 달려면 로그인하십시오.

카테고리

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