So I am running into an issue when I'm trying to download and then use an excel file. I record all the steps and use the dialog handler for "download", it saves the file. How do I then find and use that file in a coded step?
So for example. I am downloading a worksheet that has a row of data I need to validate exists. I am able to download the file correctly. But now I need to use a coded step to "find" the excel sheet I downloaded. I'm running into an issue when I try to do this.
The file downloads with a unique name (filename, date to milliseconds), so if I rename the file to something that I can repeatedly use in the coded step (setting the filepath = that name), the dialog box doesn't handle the "overwrite and rename the file if it already exists" issue.
Is there a way for Test Studio to handle this?