How to get row data and the row number for any column value in excel table
This article explains how to get row data and the row number for any column value in the excel table.
- I want to get row data(FirstName, LastName) for a particular ID.
- I want to get the row number for a particular column value in the table.
The table looks like the following:
- If you want to get row data for ID =40, you can try to fetch it in the following way using the Excel Engine:
2. If you want to get row number for the ID =40 (for example), you would need to first get the rowcount of the table and then use a while loop to verify the value of the ID until the verification fails, that is, when the value of the ID column reaches the desired value, the condition should result to False to exit the loop. You may refer to the following test case: