In excel export change the font color based on value

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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 DataOutput Required

Regards,

Abhijith V

[Anonymous]

Hi,

Any update regarding the below query.

Regards,

Abhijith V

[Anonymous]

Hello,

Any Update regarding below query.

Regards,

Abhijith V

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina