Suppose I have a column ID in the excel sheet. If I give an ID, then I should get the entire data in that row
Hi Vikram,
First of, use TestDataFactory.findTestData() to find your test data.
Then utilize the api of TestData class (documentation) to collect your data from the excel data.