Champion Level 2I 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.
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.
