Unable to Open External Program by actxserver

3 次查看（过去 30 天）
Rounak Saha Niloy
Rounak Saha Niloy 2022-3-18
回答： Shanmuganathan 2022-11-23
I am getting the following error although the same code works in another device with MATLAB R2021b.
What should I do here?
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Shanmuganathan
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

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by