Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unable to import excel sheet to qtp
#1
Not Solved Cool 
Hi friends,

can you explain me what is 1,2 in import sheet and what is Action 1 and datatable.getsheet.

Code:
systemutil.Run"C:\Program Files\Mercury Interactive\QuickTest Professional\samples\flight\app\flight4a.exe"
datatable.ImportSheet "E:\Test1.xls",1,2
d=datatable.GetSheet("Action1").getrowcount
For i=1 to d
DataTable.GetSheet("Action1").SetCurrentRow(i)
username=datatable.Value("u","Action1")
password=datatable.Value("p","Action1")
d1=datatable.Value("d1","Action1")
dialog("Login").WinEdit("Agent Name:").Type username
dialog("Login").Winedit("Password:").Type password
dialog("Login").WinButton("OK").Click
window("text:=Flight Reservation").winobject("text:=__/__/__").Type d1

Next

Thanks,
Shyam
Reply


Messages In This Thread
Unable to import excel sheet to qtp - by shyams - 04-24-2011, 01:31 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading data from excel sheet serenediva 1 8,904 03-03-2017, 10:07 AM
Last Post: vinod123
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,715 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,584 01-23-2015, 02:36 AM
Last Post: lkng2001
  How to pass a date from Excel sheet to web form revati.shendure 1 2,827 11-27-2014, 11:54 AM
Last Post: revati.shendure
  Datatable import error Prashanth 7 16,058 11-19-2014, 06:53 PM
Last Post: praveen.g3

Forum Jump:


Users browsing this thread: 2 Guest(s)