I am performing a GUI Automation process in which I am downloading a csv file from browser. Further I want to open that same downloaded csv file to process on that data. I am able to download the csv file, I need help in opening that same csv file. Also can i execute the whole process in a single workflow or do I need to create a separate workflow for opening the downloaded file.
Hi Samarth.
First of all, you can process all within one Workflow but recommended, for maintainability, separate functions.
Second, to know the name of the downloaded file, you would need to manipulate files, detect maybe latest created file and use that name to read its contents.
Also, what we do, setup browser to request filename for each download so you have total control. You will need to implement Windows GUI actions.
Hope this helps.
Hi Samarth,
You can execute the complete process within a single workflow. However, from a design and maintainability perspective, it is recommended to separate it into logical workflows (e.g., Download File → Process File).
To work with the downloaded CSV:
-
Identify the download location.
-
Retrieve the file name dynamically (for example, fetch the latest created file from the download folder).
-
Use a file-based activity such as CSV File Input Step to read and process the data instead of opening it manually through the UI.
