topic Re: tFileOutputExcel in Talend Studio

tFileOutputExcel

Anonymous — Thu, 26 Dec 2019 07:55:31 GMT

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

Re: tFileOutputExcel

Anonymous — Fri, 27 Dec 2019 05:24:24 GMT

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

Re: tFileOutputExcel

Anonymous — Sun, 05 Jan 2020 18:48:14 GMT

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