Get Excel Row Index for a given String

Question

Hi Team,&nbsp;Could you please guide me to search for a String in Excel Sheet and get the Index/ address of that Cell.&nbsp;&nbsp;For ex: In the below Excel Table, i need to search for "Fruit_ID_2" in PrimaryKey Column and get the Row Index for it.&nbsp;&nbsp;_______PrimaryKey--------Coumn2Row1&nbsp; &nbsp; &nbsp;Fruit_ID_1_______OrangeRow2&nbsp; &nbsp; Fruit_ID_2______Kiwi&nbsp;

marsha_r · Answer

You can use a DDT driver to iterate through the Excel sheet and check the primary key in each loop. If the primary key has your desired value, then save the row number and leave the loop.
&nbsp;
https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/read.html

Forum Discussion

Get Excel Row Index for a given String

Related Content

How to read Excel file using column index and row index in javaScript

How to generate a random Number, String, AlphaNumeric string

Unescape Json Strings

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

Use dynamic index in holder

Recent Discussions

Onscreen Object Selector Slowness

aqObject.CheckProperty() slowness

Problem with generated data table and keyword test

WebView2 support does not work

System checks for Object for every test