Okay, so have you come across this error while binding an Excel File as DataSource to a Test in Test Studio? You may get this error when you are working with fie saved in Excel 2013 format.
Now how to solve this error? Very easily you can solve this error by saving Excel file in Excel97-2003 Workbook format.
If you do not want and can save your file in Excel97-2003 format then probably you may want to check application log. To check application log follow these two steps,
- Navigate to Help Menu
- Click on Enable log to enable log in Test Studio.
In Log if you see something like Microsoft.ACE.OLEDB.12.0 is not registered on local machine then, you need to install Access Database Engine. You can download and install it from below link,
After installing it you should able to work with Excel file regardless of it format is Data Source in Test Studio.
I hope this post useful. Thanks for reading.