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

[Minal1]

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.

[Anonymous]

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