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 Adaptor 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 Adaptor: C:\testURLsPERIODICOS.xlsx
- Sheet: Indicates the sheet number of the Excel file we are going to work with: 1
Predefined functions (PF)
Example of a UML Diagram which uses the Excel Adaptor
Example of a UML Diagram which uses the GUI HTML Adaptor and Excel Adaptor
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 H-TEST to open them in the GUI Adaptor.
Tip: use the function getNumColumns or getNumRows and use it as the end value of the loop. Use while or for loop of H-TEST.
Solving the test case: in this first resolution, we have designed this test case using three Adaptors: the User Object Adaptor, the Excel Adaptor, and the HTML GUI Adaptor. 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.
Capture of results
When we finish executing this test case, we see if it has been executed correctly:
When we finish executing this test case, we have as a result the evidence folder, where the log of the execution is stored, as well as all the screenshots, files, etc... if we have checked the "Evidence" box in the general settings of the diagram.
When returning the results, TAST returns a Word document, detailing the steps we have taken, the results obtained from each step, the links to the diagram and the test set, if we have clicked on download document in the Results box.