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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now