freeze the header of an xlsx file

[Anonymous]

Hi everyone,

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.

1;writableSheet_tFileOutputExcel_2.getSettings().setVerticalFreeze(1)

Thank you in advance for all of your answers !

[Anonymous]

Hello,

tFileOutputExcel supports xlsx files. Does your code also work for .xlsx file in the tfileOutputExcel component?

Best regards

Sabrina

[Anonymous]

Hi xdshi,

Thanks for your reply,

My code doesn't work with .xlsx because talend use something else to create this type of file...

Florian

[Anonymous]

Hello,

Please use .xlsx file, then check the "Write excel2007 file format" option to see if it is OK with you.

Best regard

Sabrina