topic Re: Read excel file with tjavarow in Talend Studio

Read excel file with tjavarow

Anonymous — Mon, 01 Apr 2019 12:13:44 GMT

Hello everyone,

I have an excel file as input and I would like to read line by line and each column of the file using a tjavarow, but I can not can you please orient me

Regards,

Re: Read excel file with tjavarow

manodwhb — Mon, 01 Apr 2019 12:22:19 GMT

@didi ,can you verify the below screenshot,this way you need to implement.

Re: Read excel file with tjavarow

Anonymous — Mon, 01 Apr 2019 12:29:08 GMT

thank you for your return,
please if I want to tell him the line to recovered I do how
thank you

Re: Read excel file with tjavarow

manodwhb — Mon, 01 Apr 2019 12:53:54 GMT

@didi ,not understand your question,could you please elaborate ?

Re: Read excel file with tjavarow

Anonymous — Mon, 01 Apr 2019 12:57:23 GMT

I have an input excel input file that contains multiple lines I have to make a comparison between each two columns of each line example:

I have the following columns => Object_c1, Object_c2, Object1_c1, Object1_c1 ...

I have to make a comparison between Object_c1 and Objet_c2 and another comparison between Objet1_c1 and Objet1_c2 ...

If it's Ok we do not do anything but if the values are different we send it back to the output file outputexcel and we write the two values of the two columns compared

I hope I was clear enough

Re: Read excel file with tjavarow

manodwhb — Mon, 01 Apr 2019 13:10:58 GMT

@didi ,you can do below way. since i have taken two columns.

Re: Read excel file with tjavarow

Anonymous — Mon, 08 Apr 2019 15:26:49 GMT

your code works very well thank you.
I want to read line by line of a column and returned the value of the line n ° 5 for example

do you have an idea to do this please