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