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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.