Unable to Open External Program by actxserver
10 ビュー (過去 30 日間)
古いコメントを表示
I am getting the following error although the same code works in another device with MATLAB R2021b.
What should I do here?
4 件のコメント
回答 (1 件)
Shanmuganathan
2022 年 11 月 23 日
Hi Rounak,
I understand you are not able to open "Excel" from MATLAB using the function "actxserver".
Please follow the below debugging steps to resolve your issue:
- In order to determine if the issue is with MATLAB or Excel please start Windows Powershell (click start, type 'powershell' and open Windows Powershell app). In power shell, please type this
>>$excel= New-Object -ComObject excel.application
(If this produces an error then the issue is not due to MATLAB.)
- Please try the following commands in MATLAB command window to check whether other office applications are working fine:
>>word = actxserver('Word.Application')
>>p = actxserver('PowerPoint.Application')
- Re-Register the Excel Application: From a command prompt, please navigate to where the Excel.exe file is located and and open Command Prompt in Administrator mode to enter the below command:
>>EXCEL.EXE –REGSERVER
I hope the above information helps resolve your issue.
Regards,
Shanmuganathan
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Use COM Objects in MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!