Copy Files of Datatable in Folder and transform this folder to Zip-File

Help
, ,
1

Hello,

how can I copy the files in this data table into a folder?
In the next step, I want to transform this folder to a Zip-File in order to send this via email.

Excel

2

Hi @aaydin

It is possible but for that the complete Path is required.
Or
path = C:\Users\
\Desktop\Practise Solutions for Forum
If the Path like above as i have shown you as a eg will be constant always then using ForEach Activity it is possible.

Copy File Activity :-
path = path+“\”+row(0).ToString
destination = complete path of where you have to move the files

And for Zipping the files you can use below activities :-
image

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
3

Use a read range activity to save as dt1
For each row in dt1
copy file activity: path = row.item(0).tostring // destination = (put your destination here including file extension)

1 Like
4

Hi @Pratik_Wavhal

thanks for your hints!

I cannot find the mentioned Zip Activities in my Studio.

Do I need to install an additional software package ?

1 Like
5

Hi @aaydin

Yes. Der is one extra package need to install developed by @balupad14

image

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
6

Hi @aaydin and @Pratik_Wavhal . The below one is old.

Here you can get the new one here.

image
image1125×682 75 KB

Thank you
Balamurugan.S

1 Like
7

Hi @balupad14

Okies. Thanks for letting me know. :innocent:

Thats why i always tag you in post so that any updation/changes in your activities then you will let us know

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
8

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