run excel macro from simulink
显示 更早的评论
Hi All
I try to use MATLAB Function block to run Excel macro by using MATLAB Function block in Simulink. Below is my code:
function duty = fcn()
duty = zeros(1,1);
coder.extrinsic('actxserver')
excel = actxserver('Excel.Application')
excel.Workbooks.Open('D:\pso.xlsm')
excel.Run('Sheet1.run_pso');
excel.Quit;
end
However, error pop out as shown below:
Attempt to extract field 'Workbooks' from 'mxArray'.
Anyone can help me? Thank you.
3 个评论
Walter Roberson
2019-12-18
You would probably have to do something along the lines of
Workbooks = excel.Workbooks;
Workbooks.Open('D:\pso.xlsm');
However, it is possible that you would have to initialize Workbooks before doing that assignment, and initializing might be a problem in order to get the correct datatype.
Lau Boon Chong
2019-12-19
Kavya Vuriti
2020-3-30
Hi,
The error given arises when there are variables which are not initialized and assigned directly. I think the following code must work:
Workbook = excel.Workbooks.Open('D:\pso.xlsm');
excel.Run('Sheet1.run_pso');
excel.Quit;
If the error persists, could you share the excel file with the macro.
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2019-12-18
2020-3-30
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
