topic Add Password to xlsx File in Talend Studio

Add Password to xlsx File

YacineCh — Fri, 22 May 2020 10:58:54 GMT

Hello Team,

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

Thank you in advance

Re: Add Password to xlsx File

Anonymous — Wed, 27 May 2020 10:34:36 GMT

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%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2939
tFileExcelWorkbookSave
* write a workbook
* recalculate all formulas
* encrypt the file with a password
* automatically set the necessary file extension

Regards
Shong

Re: Add Password to xlsx File

YacineCh — Wed, 27 May 2020 12:43:55 GMT

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

Thank y

Re: Add Password to xlsx File

akumar2301 — Wed, 27 May 2020 15:14:44 GMT

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

talend_7.3.PNG

Re: Add Password to xlsx File

YacineCh — Wed, 27 May 2020 15:21:28 GMT

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.

Re: Add Password to xlsx File

akumar2301 — Wed, 27 May 2020 15:24:04 GMT

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.

Re: Add Password to xlsx File

YacineCh — Wed, 27 May 2020 15:28:31 GMT

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

Re: Add Password to xlsx File

YacineCh — Wed, 27 May 2020 22:24:10 GMT

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