Add Password to xlsx File

[ycham006]

Hello Team,

Please i want to add Password to my xlsx File in Talend data intégration.

Thank you in advance

[Anonymous]

Hi
The official component tFileOutputExcel does not support adding password to generated Excel file, you can try the tFileExcel components shared by jlolling on Talend Exchange.
https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...
tFileExcelWorkbookSave
* write a workbook
* recalculate all formulas
* encrypt the file with a password
* automatically set the necessary file extension

Regards
Shong

[ycham006]

Thank you. Can you explain to me how to use this component.

Thank y

[akumar2301]

If you start with 7.3 , this feature has been added.

talend_7.3.PNG

[ycham006]

Hi, 

I have the 6.1 Version. I had add the components. But i want juste to know how to use it. My needs is to take a xlsx File from my desktop and add a password to this file.

Thank you in advance.

[akumar2301]

try java code instead 

https://stackoverflow.com/questions/8817290/create-a-password-protected-excel-file-using-apache-poi

if you have any excel component in your job , all apache libraries will be automatically added to your Talend job.

[ycham006]

This code is for xls File not for xlsx files. And order problem i have to keep data and plice in the origine File to the new file.

Thank you

[ycham006]

Hello Team,

I use the costum component to add password to an existing File (xlsx ) but i have this erreur. The picture bellow explain the error and my job. Help please.

ErrorJob