topic Re: Read Excel Row Until Specific Sentinel (String) in Talend Studio

Read Excel Row Until Specific Sentinel (String)

Anonymous — Sat, 16 Nov 2024 10:05:05 GMT

Hi,
Currently, i am facing problem in reading excel file. I need to read row on excel between header and sentinel (string as a sign for stop reading). I try to read the row using tExcelInput and able to specify header row but i can't find any option to specify in which row it should stop.

So, my goal is to read 2'nd, and 3'rd row in dynamic number of rows until my reading reach "Total" (in some case, i need to read 2 rows, other 4 rows, etc). So, how it can be done?

Thanks

Re: Read Excel Row Until Specific Sentinel (String)

Anonymous — Wed, 15 Feb 2017 02:44:15 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: Read Excel Row Until Specific Sentinel (String)

Anonymous — Wed, 15 Feb 2017 06:17:55 GMT

xdshi wrote:
Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Hi, sorry for my mistake. Yesterday i already pase the screenshot but it seem that it is not appear. Here is it,
           Col A   Col B    Col C
Row 1: |No    | Name | Score
Row 2: |1      | ARD   | 11
Row 3: |2      | RDS   | 12
Row 4: |Total |         | 33

I want to read row betwen "No" and "Total" dynamically (number of row is dynamic)

Re: Read Excel Row Until Specific Sentinel (String)

Anonymous — Wed, 22 Feb 2017 10:45:13 GMT

Sorry, i made mistake by create thread in comment.