topic Re: Encrypting an excel file with password in Talend Studio

Encrypting an excel file with password

Jazz_shomp — Thu, 01 Aug 2019 06:30:47 GMT

Hello,

I am new to talend and I have a requirement to encrypt an excel file with a password (output will be an encrypted excel file which will ask for a password on opening). As I have found that there is no component available for encryption in talend Studio.

Please suggest as quick as possible !!

Re: Encrypting an excel file with password

Anonymous — Mon, 05 Aug 2019 04:06:29 GMT

Hello,

Please take a look at this component tFileArchive which creates a new zip, gzip, or tar.gz archive file from one or more files or folders.

https://help.talend.com/reader/CaNo8D_ZDQQg9Q5mFjRjyQ/rSgbu3ow3DFtyDiZMzs1IQ

Best regards

Sabrina

Re: Encrypting an excel file with password

Jazz_shomp — Wed, 07 Aug 2019 06:33:28 GMT

Yes I have used this component but when sending a mail attached with the encrypted zip file, subject of the mail get appended with WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED]. Can you let me know how to get mail without the above mentioned line appended to my mail

Re: Encrypting an excel file with password

Jazz_shomp — Thu, 08 Aug 2019 11:41:42 GMT

Also, I want my excel file to get encrypted but in this process one .zip file getting created which maybe causing this problem. I there any way where I can encrypt my excel file without using .zip file

Re: Encrypting an excel file with password

Anonymous — Thu, 08 Aug 2019 15:08:54 GMT

Hi,

In that case, you may have to use custom java code and call it from Talend routines.

I have not personally tried the code below but you could give it a try.

https://www.easyxls.com/manual/tutorials/java/encrypt-excel-file.html

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved