KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Unzip Excel file from the email

Share

Thabiso.Phakula@eoh.com

Posts : 6
Points : 152
Join date : 2018-06-28

Unzip Excel file from the email

Post by Thabiso.Phakula@eoh.com on Wed Oct 31, 2018 4:27 pm

Hi,

Can anyone advice on how to unzip excel file from email. 

your help will be highly appreciated.

Tthanks
avatar
pavel.vraj

Posts : 78
Points : 822
Join date : 2016-11-04
Location : Prague, Czech Republic

Re: Unzip Excel file from the email

Post by pavel.vraj on Wed Oct 31, 2018 8:46 pm

Hi,

as first, you have to get the ZIP file from the email. As soon as you'll have the ZIP content, save it to file system and then use an "unzip.exe" file via "Command line" step and extract the whole content of the ZIP file. Then you have your Excel and can load it into a global variable.

How to get the ZIP from email depends on your email client. You can use web to login there and download it.

Unzip.exe is not a part of Kapow. You have to download the opensource file from web, save it into specific folder, which will never change like "C:\Program Files\Kapow\unzip.exe" and then you can use it.

Best regads,
Pavel Vraj

    Current date/time is Thu Nov 15, 2018 12:06 pm