topic tFileExcel in Talend Studio

tFileExcel

Anonymous — Sat, 16 Nov 2024 08:17:30 GMT

Dear all, my job give me an Excel output and i would like to make some changes as:

- Set the header with a color and the text of the header with another color

- Color the values of a Column which are > of 5

and other changes to the excel output.

What is the component who helps me?

i am trying to use the tFileExcel component but the Job give me that error:

someone who helps me? thanks in advance, Sam

Re: tFileExcel

manodwhb — Thu, 10 May 2018 06:54:49 GMT

@samfantini,You have not specified Workbook in Basic settings of the tFileExcelSheetOutput.

Re: tFileExcel

Anonymous — Thu, 10 May 2018 08:05:22 GMT

@manodwhb, i Have set the Workbook Open and the Workbook Save. So the component in general is useful to keep the format of an output excel. But i have to set the format before and is not possible to set the format with the component in the job, did I get it right?

Re: tFileExcel

Anonymous — Thu, 10 May 2018 08:08:47 GMT

Hi Sanfantini

Please tell me the procedure to download tFIleExcel component.

I did it through exchange but cant see that in pallette.

Re: tFileExcel

Anonymous — Thu, 10 May 2018 08:46:58 GMT

https://community.jaspersoft.com/wiki/installing-customer-or-community-components-jaspersoftetl-talend-etl

that is the link with the procedure.

You have to download the Component from the Exchange, then unzip the folder where you want.

Then you have to go in Talend-> Windows -> Preferences-> talend component design -> set the path of the folder which contains the Component

the same things also in Talend->Windows ->Preferences ->Talend -> Components -> set the path of the folder which contains the Component

and then restart Talend

Re: tFileExcel

Anonymous — Thu, 10 May 2018 10:36:09 GMT

Hello,

Here is online document about:TalendHelpCenter:How to install and update a custom component.

Best regards

Sabrina

Re: tFileExcel

Anonymous — Thu, 10 May 2018 10:37:22 GMT

thank you