Troubleshooting Excel COM Interface Issues in Jenkins Workflows

I am using Excel with COM Interface (actxserver) in my Jenkins workflow but am encountering errors. How can I troubleshoot these errors?

Answer 1

[MathWorks Support Team]

To troubleshoot errors related to Excel with COM Interface in Jenkins workflows, please follow the steps in this article: Why do Jenkins builds with MATLAB fail on a Windows machine?

If that doesn’t resolve the issue, please run this PowerShell script in Jenkins, to determine if the issue is independent of MATLAB.

$excel= New-Object -ComObject excel.application
$excel.visible = $true
$wb = $excel.Workbooks.Open("<full path to file>")
$excel.quit()