Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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