Apply background color in tFileOutputExcel

[Anonymous]

hi,
I begin a new job, and i work now in some jobs talend.
I have a question : Is it possible to apply a background (color) in cell if some condition are true ?
I saw Tjava and TjavaRow component, and i saw we could use jxl.jar or anything else. But i really dont know java code, and i really dont know if i can do that.
Why ? my file excel need to apply some format when the job is over, and i apply manually some format. It very long, because my file is very heavy (more 100 000 lines)
So i would like to apply those formats automatically. 
I though to use Macro Excel, but it's not a good solution ...
Any idea...?

[Anonymous]

Hello @ashwindhiware

It 's a very old thread. Could you please give us a more bit information about your current requirement and description?

Best regards

Sabrina

[Ganshyam]

Hi Jlolling,

I am using the above 3 components to generate conditional formatting in excel template. The data is getting populated from input file to template but don't have the data with conditional formatting in the excel template.For integer records in input file it is working fine. But the input format has data in % and want to conditional format this % values in conditional formatting in template.

Attached are the screenshot of the job and the component setting.

Let me know if i have missed out some configuration to talend component.

Regards

Ganshyam