Search and import data from excel under some rules. - Printable Version +- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums) +-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP) +--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming) +--- Thread: Search and import data from excel under some rules. (/Thread-Search-and-import-data-from-excel-under-some-rules)

Search and import data from excel under some rules. - nwpulele - 02-12-2015 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. RE: Search and import data from excel under some rules. - nwpulele - 02-13-2015 Question solved by myself. RE: Search and import data from excel under some rules. - supputuri - 02-19-2015 please post the answer so that it would be helpful for other folks.