HomeHi,
Can anyone advice on how to unzip excel file from email.
your help will be highly appreciated.
Tthanks
Can anyone advice on how to unzip excel file from email.
your help will be highly appreciated.
Tthanks
2 posters
Unzip Excel file from the email
Thabiso.Phakula- Posts : 6
Points : 2142
Join date : 2018-06-28
pavel.vraj- Posts : 86
Points : 2823
Join date : 2016-11-04
Location : Prague, Czech Republic
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
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