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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.