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?
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)
