I would like to frezze the header (first line in excel) with Talend or java.
I've succed with the .xls extention in Talend by doing a litle trick in the excel component (TfileOutputExcel), I just put this litle code in the cell name "first cell", but now I would like to be able to do that with a .xlsx file.
Thank you in advance for all of your answers !
tFileOutputExcel supports xlsx files. Does your code also work for .xlsx file in the tfileOutputExcel component?
Thanks for your reply,
My code doesn't work with .xlsx because talend use something else to create this type of file...
Please use .xlsx file, then check the "Write excel2007 file format" option to see if it is OK with you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables