I need to retrieve the row number based on a value in datatable i.e. I am looking for a method which can search the specified value in datatable and return the row number similar to GetRowWithCellText. I thought to search the value by looping through all rows in a sheet, but the datasheet contains roughly 2000+ rows. Is there any other alternate way?
Re: Retrieve Row Number based on Values in Datatable
I know that there is a way to connect to an external data sheet and use it as a data base. Then you talk with the data sheet using Select Statements. I think that you could use this system and connect to the default.xls data sheet that is in the folder with the script. Since you are only doing a read, I think that you can attach to it even when QTP is using it as the run time book.
When in Florida, Don't Tampa with the code. I made this up.