Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
1) I need to read Microsoft Excel file like this:
2) filter red lines and move them to another excel file.
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
it is only the font color, any suggestions via Java code using tJavaRow, or tJava?
Hello,
We need to make an investigation on your issue and then come back to you as soon as possible.
Best regards
Sabrina
Great, thanks
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?
Thank you for the reference, I`ll take a look and give feedback about it.
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