[resolved] How to extract specific cell from multiple excel in a folder

[Anonymous]

Hye, 
I need to extract specific cell from multiple excel in a folder.
But, I have a problem which is the output is repeated. 
How to solve the problem? Here, i attached the screenshot what im used to show the output.

[Anonymous]

Hi,
Can anyone give me some suggesstion how to solve the problem... pleasee advice me... TQ...

[Anonymous · Accepted solution]

At first you do not reset the sequence, means every file the sequence value will grow.
Next you write the context variables once but never again, because of that you will always get the same value.
To get an idea what I mean I suggest you set null the values before you set the values, you will see you get mostly null values instead of always the same value.
I would use a tJavaFlex instead of tJavaRow and reset the sequence in the begin part or use simply the file name as name for the sequence.

[Anonymous]

What do you meant set null the values before set the values? Can you give me some examples how to set the null value?
Can we set the null value in tJavarow?

[Anonymous]

Mr. Jlolling, 
How to use tJavaFlex? Can you give me some example how to set in tJavaFlex? Example, i want to extract specific data from D1, J1, and B3 in excel file...
Did i should replace tJavaRow with tJavaFlex in my job design... it is right? TQ

[Anonymous]

Hey, it is your Java code and this has nothing to do with Talend. 
I would simply implement my last suggestion and use the file name as name for the sequence
Instead of "s1" use ((String)globalMap.get("tFileList_1_CURRENTFILE")).
This way you start a new sequence for a new file and the you will get the values always from the right number of rows.

[Anonymous]

tQ so muchhh..... i have successfully completed... 😃