Working with Excel in tJava

[EnriqueLDE]

Hello,

I'm not use to program Excel using Java (i always use Visual Basic) and i recently realized there isn't any tool to program Excel using vba in Talend, instead u have to use tJava. But i have no idea how to program Excel in Talend using Java code. Is there any library to upload or tutorial where i can learn about this?

Thank you!

[akumar2301]

Try to re implement your VBA code using Talend components.

Otherwise you could call your VBA script using tJava .

Runtime.getRuntime().exec("wscript yourmacro.vbs");

[EnriqueLDE]

I need to use conditions like this example:

If CODE = 1 and ID STATUS = C Then Result = 1C (This is the logic i'm looking for, but i don't know how to do this using tJava or Talend components)

Capture.PNG

[akumar2301]

Read input (1st two cols) --> tjava ( create 3 column col3=col1+col2) --> thashoutput ( only col3)

on subjob ok

thashinput(Only col3) --> excel file output ( write only 3rd column on same excel and same sheet in append mode from position C2)

Hope this will help to understand how these components works. There are many custom excel component on Exchange portal. if you need to work a lot on excel those also might be useful.

TalendSolution_2.JPG