latamindq

 Profile Answers by latamindq 

• Feb 27th, 2008

 

We can submit the external file in the data table using the import , when we change the script at the values, then by using the output value u can get the result in the run-time data table.

RicGupta1984

 Profile Answers by RicGupta1984 

• Mar 3rd, 2008

 

''creation of new sheet using import function:-
'let say new sheet has two columns userid and password.

 v=DataTable.AddSheet ("newsheet").AddParameter ("ColumnName Time","ColumnValue 8:00" )
'msgbox"go"

'''new sheet "gupta" will be created..

DataTable.ImportSheet  "c:/name.xls","gupta","newsheet"

''here 1 is first columnname of newly imported sheet, 3 is index of newly created 'sheet:provided "gloabl", "action1" were already there.global's index is 1, action's 2 and so on.

x = datatable.Value (1,3)
''here 2 is first columnname of newly imported sheet
y = datatable.Value (2,3)
msgbox x
msgbox y

'IMPORTING data from QTP to APPLICATION...
''open your application.here i had used IE

SystemUtil.Run "C:Program FilesInternet Exploreriexplore.exe","","C:Documents and Settings...
wait (10)
Browser("Browser").Navigate  ("open ANY BROWSER")
wait(10)

Browser("Browser").Page("Gmail: Email from Google").WebEdit("Email").Set datatable(1,3)
Browser("Browser").Page("Gmail: Email from Google").WebEdit("Passwd").Set datatable (2,3)
Browser("Browser").Page("Gmail: Email from Google").WebButton("Sign in").Click

'''NOW PUT OUTPUT VALUE CHECKPOINTS for capturing values through application.

'thanks