How to refer to already open Excel file?

Learning & Development Programs Automation Starter
1

Hi All,

I have found similar topics on the forum, but solutions there don’t solve my challenge.

My robot works with online application, downloads Excel file and the file opens immediately. The filename varies each time the download is executed. Active window shows the open excel file. I would like to work with the downloaded file, but don’t know how to refer to it in Studio X / Studio. Could you please suggest any solution?

Thank you in advance,
Kaz

2

Hi @kgkorespondencja

How are you downloading the excel file? Are you using the Wait For Download Activity for it?

If it is so, then you can easily refer the downloaded file.

https://docs.uipath.com/activities/docs/get-last-downloaded-file

1 Like
3

Hi kumar.varun2,

Thank you for your questions.
I’m using Click activity and the target is set for image region selection.

4

@kgkorespondencja

Try the Wait For Download Activity

image
image454×515 10.6 KB

The DownloadedFile variable is a FileInfo Type variable, which contains all the information related to the downloaded file.

image

Refer this xaml

WaitForDownload.xaml (9.3 KB)

5

Hello @kgkorespondencja

Here as solution what you can do is

  1. First delete all the file in the folder . you can use Delete file activity.
    2)Click on the file to download
    3)Use WAIT FOR DOWNLOAD to check the file downloaded.
  2. use assigna ctivity and use expressions as Directory.Getfiles(“Folderpath”)
    5)You can use start process to open the file.
6

@kumar.varun2 & @Rahul_Unnikrishnan I’ll follow you suggestions and come back with feedback when ready.
Thank you

1 Like
7

@kumar.varun2 I’ve followed your suggestions and succeeded. Thank you for your support.
Kaz

1 Like
8

@Rahul_Unnikrishnan Thank you for you suggestion.
Kaz

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.