Excel File Adaptor examples

Through the Excel Adaptor, TAST 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.

This is an example of a UML Diagram which uses the Excel File Adaptor. This is a technical testing of the Predefined Functions of the Adaptor.





This is an example of interactions between the Excel File Adaptor with other adaptors in an E2E test.




As part of the mapping process, you should provide the Adaptor’s information, regarding to connect and use it:

• FilePath: Represents the full path and name of the Excel file that represents this instance of the Excel adapter.
• NumSheet: Indicates the number of the sheet within the Excel workbook on which we want to work.
• Template: If is selected, the file will be created or overwriten in any case, with independence if the checkbox 'Create/Overwrite' has been selected.
• Create/Overwrite: When the checkbox is marked, TAST will create a new file or overwrite it if the file already exists.

After the test set execution, immediately you have the results. There are two main elements you can verify:

• Logs: The step by step information of the execution, with:
  • the results.
  • the methods had been executed.
  • the timelines.
• Evidences: The screenshots or evidence information by step, in case they have requested. Also the evidence file, in case they have requested as well.