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 ...

Get Agile Automation and Unified Funtional Testing now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.