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

1 Reply

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

Mapped object - use wildcard on Index

Excel-Write value

Recent Discussions

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons