topic Reading excel color font cell in Data Quality

Reading excel color font cell

Valentinas — Fri, 15 Nov 2024 23:25:27 GMT

Hi,

I need to filter out excel colored text lines, I found that tFilterRow is not able to do it, is someone were able to resolve that using Java code or some other way?

BR,

Val

Re: Reading excel color font cell

Anonymous — Mon, 13 Dec 2021 08:07:33 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Reading excel color font cell

Valentinas — Mon, 13 Dec 2021 08:13:49 GMT

1) I need to read Microsoft Excel file like this:

2) filter red lines and move them to another excel file.

Re: Reading excel color font cell

Anonymous — Mon, 13 Dec 2021 08:37:33 GMT

Hello,

I'm afraid that Talend tool would not be able to interpret the color font in excel file. Is there any other condition or rule to know the color font start line and end line? A number or Id?

Best regards

Sabrina

Re: Reading excel color font cell

Valentinas — Mon, 13 Dec 2021 08:44:45 GMT

it is only the font color, any suggestions via Java code using tJavaRow, or tJava?

Re: Reading excel color font cell

Anonymous — Mon, 13 Dec 2021 09:06:49 GMT

Hello,

We need to make an investigation on your issue and then come back to you as soon as possible.

Best regards

Sabrina

Re: Reading excel color font cell

Valentinas — Mon, 13 Dec 2021 09:09:35 GMT

Great, thanks

Re: Reading excel color font cell

Anonymous — Tue, 14 Dec 2021 09:27:04 GMT

Hello,

With the right libraries that should be able to work, but I don't know how to do it.

Here are some excel custom components written by Jan Lolling, which might help.

Could you please take a look at it?

Jan LollingtFileExcel-Components

Re: Reading excel color font cell

Valentinas — Tue, 14 Dec 2021 12:00:39 GMT

Thank you for the reference, I`ll take a look and give feedback about it.

Re: Reading excel color font cell

Valentinas — Mon, 27 Dec 2021 14:51:27 GMT

Hi,

could you help me? Trying to download that plugin, but looks like my user does not have permission to do so. Do I have to use a different user to https://exchange.talend.com/#signin:?

BR,

Val

Re: Reading excel color font cell

Anonymous — Wed, 29 Dec 2021 08:29:14 GMT

Hello

It should be your talend forge credentials (talend jira) not talend community.

Best regards

Sabrina