I am executing a automation test for webservices written in C# and I have my test data in the excel spreadsheet. When I am running my test using visual studio to my local machine then it all works fine. But when I try to run these tests through commandline using Nunit-Console.exe
command then all the tests fails because of this error.
[Error] - Unable to read all data from spreadsheet. System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Excel version that I am using is "Microsoft Excel 97-2003 Worksheet (.xls)"
Can you please advise some solution for this.