topic Re: Working with Excel in tJava in Talend Studio

Working with Excel in tJava

EnriqueLDE — Tue, 15 Jan 2019 11:26:12 GMT

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!

Re: Working with Excel in tJava

akumar2301 — Tue, 15 Jan 2019 13:07:42 GMT

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");

Re: Working with Excel in tJava

EnriqueLDE — Tue, 15 Jan 2019 14:25:37 GMT

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

Re: Working with Excel in tJava

akumar2301 — Tue, 15 Jan 2019 16:19:46 GMT

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