Five Stars abi
Five Stars

In excel export change the font color based on value

Hi,

 

I need to change the font color in excel based on the field value using TOS, while exporting excel.

 

Can anyone suggest a solution for this.

 

I am using TOS 6.3.2.

 

Regards,

Abhijith V

7 REPLIES
Moderator

Re: In excel export change the font color based on value

Hello,

Could you please set an example for us? Elaborating your case with an example with input and expected output values will be preferred.

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.
Five Stars abi
Five Stars

Re: In excel export change the font color based on value

Hi Sabrina,

 

Thanks for your response.

 

With reference to below mail please find attached input details and output required excel format.

 

This needs to be done using Talend.

 

Please kindly advise the same at the earliest.

 

input.PNGInput DataOutput.PNGOutput Required

Regards,

Abhijith V

Five Stars abi
Five Stars

Re: In excel export change the font color based on value

Hi,

 

Any update regarding the below query.

 

Regards,

Abhijith V

Five Stars abi
Five Stars

Re: In excel export change the font color based on value

Hello,

Any Update regarding below query.

Regards,

Abhijith V

Moderator

Re: In excel export change the font color based on value

Hello,

You can use a combination of the tAggregateRow and the tMap with the custom function to make your scenario happen.

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.
Five Stars abi
Five Stars

Re: In excel export change the font color based on value

Hi,

Thanks for the reply.

I got the output. But I need to highlighten the cell as in the screenshot. Kindly suggest the component for performing the same.

Output.PNG

Moderator

Re: In excel export change the font color based on value

Hello,

So far, there is no a specific component for changing the color of your text in talend.

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.