topic Re: In excel export change the font color based on value in Data Quality

In excel export change the font color based on value

Anonymous — Mon, 26 Mar 2018 10:25:40 GMT

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

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

Anonymous — Tue, 27 Mar 2018 04:54:00 GMT

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

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

Anonymous — Tue, 27 Mar 2018 07:41:22 GMT

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

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

Anonymous — Tue, 10 Apr 2018 04:46:15 GMT

Hi,

Any update regarding the below query.

Regards,

Abhijith V

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

Anonymous — Tue, 10 Apr 2018 05:46:27 GMT

Hello,

Any Update regarding below query.

Regards,

Abhijith V

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

Anonymous — Thu, 12 Apr 2018 03:34:04 GMT

Hello,

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

Best regards

Sabrina

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

Anonymous — Thu, 12 Apr 2018 05:01:10 GMT

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.

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

Anonymous — Thu, 12 Apr 2018 11:01:55 GMT

Hello,

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

Best regards

Sabrina