+- 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: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Import multiple values from excel into QTP (/Thread-Import-multiple-values-from-excel-into-QTP)
Import multiple values from excel into QTP - Shaik Ahmed - 03-09-2014
Hi All,
I am new to QTP and I am stuck with usage of datatables in QTP. Can you please help.
Requirement:
An excel sheet contains one customer and multiple ISBN. I need to pull customer and ISBN data from excel and need to place order. Here can you please let me know how can i do it in QTP. I tried data table but it didnot work for more than 1 ISBN.
Table in Excel:
Customer ISBN
Anil 9878998876 ## ISBN 1 in one cell
8976567777 ## ISBN 2 in another cell
RE: Import multiple values from excel into QTP - ankur1601 - 03-09-2014
Hi,
Could you share excel so that i will tell you how to import your data from excel.
RE: Import multiple values from excel into QTP - Shaik Ahmed - 03-09-2014
Hi Ankur,
Thanks for the reply. Please find the sheet"Order_data.xls" attached.
Thanks,
Ahmed
Ankur,
I was not able to attach the sheet. But however as the data was less I have taken a screenshot of sxcel and attached the same.
The Excel has only one sheet with name "sheet1"
[attachment=1297]