swarna

• Sep 20th, 2006

 

go to step-action properties-parameter in inputparameters add

give the name of the parameter and in default value give the path of the excel sheet ex D:swarnadatasheet.xls like

i will explain this using insert in flight application

ids=parameter("inputdatasheet")
datatable.AddSheet("inputdatasheet")
datatable.ImportSheet ids,1,"inputdatasheet"

For i=1 to datatable.GetSheet("inputdatasheet").getrowcount
 datatable.SetCurrentRow(i)

 
Window("Flight Reservation").Activate
Window("Flight Reservation").WinMenu("Menu").Select "File;New Order"
Window("Flight Reservation").ActiveX("MaskEdBox").Type "1010101"
Window("Flight Reservation").WinComboBox("Fly From:").Select "Frankfurt"
Window("Flight Reservation").WinComboBox("Fly To:").Select "London"
Window("Flight Reservation").WinButton("FLIGHT").Click
Window("Flight Reservation").Dialog("Flights Table").WinButton("OK").Click
Window("Flight Reservation").WinEdit("Name:").Set datatable.Value("name","inputdatasheet")
Window("Flight Reservation").WinButton("Insert Order").Click

Next

in above example my parameter name is inputdatasheet,excelsheet name is inputdatasheet, and variable name is ids

in bove ex i did parameterization in Expert view.

if u have any mail me at  swarna_nalla@yahoo.com