Forum Discussion
5 Replies
- rraghvani
Champion Level 3
The Dynamic Link Library (DLL) file mso20win32client.dll, relates to Microsoft/Office 365. If you search the internet for this DLL, there will be plenty of information on how to resolve this, i.e. repair Microsoft/Office 365 or Windows Update
- scot1967
Champion Level 2
I have seen recommendations to "Avoid Office automation in DevOps pipelines and use server-safe libraries instead". Is MS Office installed on your build machine? Does the build machine have a GUI or is it headless? Office needs a GUI. rraghvani has you on the right track. These are just few things I know to cause problems like this.
- AmolGawaliOccasional Contributor
Thank you, scot1967 & @rraghrraghvani for your inputs.
MS Office is not installed on my machine, but i have installed Access Database engine 2016 by using which we can use the Excel, and i am using excel only for Data driven testing.
it is a non-interactive session i am using though pipelines and not getting error when running the same test scrpts locally on same machine.
- scot1967
Champion Level 2
The DevOps pipeline environment will need the same setup as your local pc. Maybe the dll is missing or a different version on the server? I would check the pipeline server. We use Excel in TestComplete with a pipeline here and it works well. Our pipeline server needed to have the correct files to make it work however. Ensure you have "Access Database engine 2016" setup correctly on you pipeline server as you have locally.
We use the Excel object in scripts as shown in this link...
https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html - scot1967
Champion Level 2