Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Minal1
Contributor
Contributor
‎2020-01-11 02:15 AM

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

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.

Labels (2)
Labels
279 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2020-01-13 10:07 PM

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
279 Views
0 Likes