O'Reilly logo

Agile Automation and Unified Funtional Testing by Rajeev Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 45

Working with Microsoft Excel

Microsoft Excel is a spreadsheet application developed by Microsoft Corporation for storing, organizing, and manipulating data. It features calculation, graphic tools, pivot tables, and a macro programming language called VBA (Visual Basic for Applications). Generally, in test automation, Excel is used as test data sheets for storing the test input data. There are two ways in which we can access MS Excel file in test automation:

  • Excel as workbook
  • Excel as database

Excel object model is used to access Excel as workbook. In case of using Excel as database, Excel is treated as any other database such as MS Access and SQL queries are executed on it. In test automation, using MS Excel as database has specific ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required