Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Search and import data from excel under some rules.
#1
Solved: 9 Years, 1 Month, 2 Weeks ago
Hi All,

I'm a QTP beginner.

I'm wondering if there is a way to search and import data from an Excel sheet under some specific rules.

For example, I need to search value "123" under A column. Once found, for example, at "A2" cell, I need to import "A2" and "B2" cell to QTP datatable.

Sometimes, I need to search value like "456" under A column. If it is found at "A3", I need to import "A3", "B3" and "C4".

I'm wondering if it is possible to do this.

Thank you.
Reply
#2
Solved: 9 Years, 1 Month, 2 Weeks ago
Question solved by myself.
Reply
#3
Solved: 9 Years, 1 Month, 2 Weeks ago
please post the answer so that it would be helpful for other folks.
Thanks,
SUpputuri
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  how to select value from google search box dropdown +QTP prajyot 0 2,643 06-28-2017, 06:30 PM
Last Post: prajyot
  How to populate data in weblist using excel vijifun 1 3,049 12-05-2013, 12:06 PM
Last Post: basanth27
  Does QTP support writing runtime data to multiple sheets in excel Shwethareddy 2 3,529 10-16-2012, 12:20 PM
Last Post: Shwethareddy
  Cast Excel Data into a 2-D Array ravi.gajul 0 2,376 06-20-2012, 03:07 PM
Last Post: ravi.gajul
  Send Data from MSWord document 2 Excel File kisskasa 0 2,770 01-10-2012, 01:51 PM
Last Post: kisskasa

Forum Jump:


Users browsing this thread: 1 Guest(s)