Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileOutputExcel

Hello Everyone,

 

I am facing issues in a requirement.

 

The output Excel File created should already have the filter in the header so that after creation when user is reading the file he/she should directly have the option to filter column and no need to do that manually, is there any way we can do that?

 

Thanks

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hello,

So far, we don't have the filter in header in tfileoutputexcel component.

Feel free to create a new feature jira issue on talend bug tracker.

Best regards

Sabrina

Anonymous
Not applicable
Author

The build-in excel components are not able to handle styles tellsubway.
The only way to apply styles (like conditional formatting) is using the component suite tFileExcel*
You need 3 components:
tFileExcelWorkbookOpen to open an existing file (containing your styles and formats) or create an new empty workbook 
tFileExcelSheetOutput to create/write a sheet