topic Re: Excel set cell colour in Talend Studio

Excel set cell colour

veryimportantdude — Sat, 16 Nov 2024 12:30:40 GMT

Hello
Is it possible to set field colour in an excel Output file based on condition?
For example:
if value <0:
colour = red
else:
colour = green

thank you

Re: Excel set cell colour

Anonymous — Thu, 15 Dec 2011 06:03:04 GMT

Hi
You mean you want to set background color of cell by TOS directly?
I think it is impossible to do this. Because TOS doesn't import thirdparty library for this demand.
Best regards!
Pedro

Re: Excel set cell colour

juliusmark — Fri, 29 May 2020 08:46:57 GMT

Hi Guys,

I also have the same requirement. Has anyone did it already?

Can this be achieved using the tFileExcel-Components found at:
https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2939

Cheers!