Import multiple values from excel into QTP

[Shaik Ahmed]

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

[ankur1601]

Hi,

Could you share excel so that i will tell you how to import your data from excel.

[Shaik Ahmed]

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"