How to Zip Multiple Excel Files

Help
, ,
1

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

2

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…

3

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

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

4

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

5

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.

image
image1228×447 24.8 KB

image
image1426×633 28.5 KB

Regards
Balamurugan.S

6

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

7

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.

Example2
Example2967×180 9.26 KB

8

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.

Example2
Example2967×180 9.26 KB

9

@srinivasanma

Try this solution.
Main.xaml (7.9 KB)

10

Hi @srinivasanma

Screenshot…
Design:

image
image873×702 19.7 KB

Output

image
image1017×262 15.3 KB

Here I have attached the sample …

srinivasanma.zip (39.5 KB)

Regards
Balamurugan.S

11

Thanks bro… its working fine.

12

thanks for the response and solution

13

Welcome @srinivasanma …

14

This is great! How would I modify the Zip activity to zip multiple folders in the file path and keep the zip file the same as the folder? With the folder these is no extension to replace.

File Path:
Folder1
Folder2
Folder1.zip
Folder2.zip

16

@srinivasanma Use for each file in folder activity inside tat use a assign activity as path=CurrentFile.FullName after assign use zip activity and pass on the variable as input file path for the zip activity