freeze the header of an xlsx file

Four Stars

freeze the header of an xlsx file

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 ! Smiley Happy

Moderator

Re: freeze the header of an xlsx file

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: freeze the header of an xlsx file

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

 

Moderator

Re: freeze the header of an xlsx file

Hello,

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

Best regard

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.