Unzip downloaded file and auto open excel file

Help StudioX
,
1

Hi All,

I’m trying to get UiPath to auto unzip a latest downloaded folder and open the below file for me to work on. Anyone knows how I can do it?

Latest downloaded folder:
image

And to open this file within the folder starting with ‘private’:
image

Link to download the zip file is

I can auto download it, but not sure how can I unzip the downloaded folder and open the above excel file automatically. Any example is be greatly appreciated!

image
image1107×129 4.94 KB

Thanks.

2

Hey @victorialim,

You can use Extract/UnzipFiles activity to unzip the file.
And use Excel or Workbook activities to work with excel

Thanks,
Sanjit

3

Hi

  1. Use Extract/UnzipFiles activity to unzip the file.
    https://docs.uipath.com/activities/lang-fr/docs/extract-files

  2. Use get file directory

  3. Then u will get file one by one unzipped

Regards,
Dhanush

4

Hi, I meant to auto open the particular excel file starting with ‘private’ as the name changes every time. Thanks

5

Hey @victorialim,

  1. You can get the file starting with prefix as private with
    LHS
    ListOfFiles

RHS
Directory.GetFiles(“FolderPath”,“private*.xlsx”)
2. For each file you can use Excel or Workbook activities to work with excel as said before.

Thanks,
Sanjit