Encrypting an excel file with password

[Jazz_shomp]

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 !!

[Anonymous]

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

[Jazz_shomp]

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

[Jazz_shomp]

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

[Anonymous]

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