TestProject Forum

How to locate a downloaded excel file during test and validate it?

  1. How to locate the path of the excel (.xlsx )file ? ( part of execution an excel file will be downloaded )

  2. How to validate them against the values in the web pages?

Note : This has to be performed in Jenkins / AWS, not in local machine.

Many Thanks!
Hari

Hi @Hari,
As we discussed in the chat.
You can do this by first using the action get path of latest downloaded file
then use the action get Data from excel file and get text from UI website, then compare values in the validation of the step.