How to Zip Multiple Excel Files

Hi,

with the help of Blalreva.zip activity i can zip an excel, but i have to zip multiple excel ( each single excel file should zip with the excel file name ).

please help me

1 Like

First get all file names from the folder, pass that each file name inside a for each loop and convert each excel file into zip file inside the for eah loop…

2 Likes

@srinivasanma
1.use for each…to iterate excel files.
Directory.GetFiles(FolderPath,"*.xlsx")

2.Inside for each, you can use zip file activity.

2 Likes

Hi Srinivas , Welcome to the Forum

please use for each loop
FOR EACH of Directlry.getfiles(folderpath","*.Xlsx")

The argument should be string

Now place the zip file activity inside the body of the for each loop

2 Likes

Hi @srinivasanma,

Welcome to UiPath Forum community.

Here I have attached the sample for you.

srinivasanma.zip (17.7 KB)

Here is the screen shot.

Regards
Balamurugan.S

Hi Community,
in the same way if I would like to unzip easily zip or 7z file does uipath has an activity to do that ?
Thanks a lot for your answer

Regards

1 Like

Thanks for the solution bro, i needed like i have more files in a folder and i have to zip each single file i mean each single excel file into each single zip file. I have attached the screenshot for your reference.

Thanks for the solution bro, i needed like i have more files in a folder and i have to zip each single file i mean each single excel file into each single zip file. I have attached the screenshot for your reference.

@srinivasanma

Try this solution.
Main.xaml (7.9 KB)

Hi @srinivasanma

Screenshot…
Design:

Output

Here I have attached the sample …

srinivasanma.zip (39.5 KB)

Regards
Balamurugan.S

Thanks bro… its working fine.

1 Like

thanks for the response and solution

2 Likes

Welcome @srinivasanma