How To Read excel using adodb connection

Excel workbooks are the most common and an excellent way of storing data. Did you know you can connect to the excel workbook as a database using vbscript and read data from it? Amazing isn’t it?  When working as Test automation Engineer, you will come across many use cases around excel files. There can be some scenarios where you have to read data from excel at runtime and you can do this by treating th excel workbook as a database. VBScript provides ADODB object using which you can establish a connection to the excel file as a database and read the data. You can also pass the normal sql queries to find the data in it. Just as you would if working with a database.

This page has list of all the functions which you can use to read an excel using adodb connection with the workbook.