topic How can we convert Output Excel Cells into Non-editable format in Talend in Talend Studio

How can we convert Output Excel Cells into Non-editable format in Talend

Minal1 — Sat, 16 Nov 2024 03:36:56 GMT

Hi all,

I have job which read excels file and some transformation are put on that data. After transformation data is saved into Output Excel using tFileExcelOutput components. But my requirement is what ever data i trasform into cells that should be non editable.

So after generation of output excel, user should not be able to edit it.

can we perform this using Talend ?

Please suggest some ways.

Re: How can we convert Output Excel Cells into Non-editable format in Talend

Anonymous — Tue, 14 Jan 2020 03:07:32 GMT

Hi
The tFileOutputExcel component don't have this functionality, according to this page on stackoverflow,
https://stackoverflow.com/questions/8397169/lock-single-column-in-excel-using-apache-poi
it is able to lock the excel file using Apache POI, if you are a Java developer, you can have a try to open the file and lock it after the file is generation or modify the source file of tFileOutputExcel.

Regards
Shong