Excel File Adaptor Example

Introduction

Through the Excel Adaptor, H-TEST can manage Excel files (of .xls and .xlsx types) and test them. It’s possible to perform single tests with this adaptor or end to end tests connecting with other adaptors either.

Initialization parameters

The Excel Adapter will attempt to read and parse the Excel sheet. The necessary initialisation parameters for this example are the following:

FilePath: Represents the full path and file name of the Excel file being handled by this instance of the Excel Adapter: C:\testURLsPERIODICOS.xlsx

Sheet: Indicates the sheet number of the Excel file we are going to work with: 1

Predefined functions (PF)

This is an example of a UML Diagram which uses the GUI HTML Adaptor and Excel Adaptor Exercise

 

Statement of the exercise

With an Excel and a loop, open 6 web pages: Create an Excel with different URL's and collect them with TAST to open them in the GUI adapter.

Tip: use the function getNumColumns or getNumRows and use it as the end value of the loop. Use while or for loop of TAST

Solving the test case

In this first resolution, we have designed this test case using three Adapters: the User Object Adapter, the Excel Adapter, and the HTML GUI Adapter. We have also created the WHILE loop, with which we will execute the same steps, as long as the condition we indicate in the properties of the Fragment is fulfilled.