tFileExcel

Five Stars

tFileExcel

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:

Cattura.PNG

someone who helps me? thanks in advance, Sam

Forteen Stars

Re: tFileExcel

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: tFileExcel

@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?

Eight Stars

Re: tFileExcel

Hi Sanfantini

 

Please tell me the procedure to download tFIleExcel component. 

 

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

Tags (2)
Five Stars

Re: tFileExcel

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

 

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 

Moderator

Re: tFileExcel

Hello,

Here is online document about:TalendHelpCenter:How to install and update a custom 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.
Eight Stars

Re: tFileExcel

thank you

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now