I am unable to read the excel in the requirement format for example attached the sheet.
In the sheet there are two table’s i was able to read the first once as its “static” shown below how ever recognising Column as a header is also been worked upon.
However i am unable to read a dynamic table highlighted below in the same sheet as there is possibility of having more row which cant be predicted.
Can you please assit me on how to read both the table from single sheet only.
Syed.Testcase.xlsx (11.6 KB)