12-05-2013, 11:51 AM
In the below coding i have populated data from excel in webedit but its not populating in wblist. Please any one help me
This is my code
This is my code
Code:
Option Explicit
dim xl,sh,row,col,i,j
set xl=CreateObject("Excel.Application")
xl.Workbooks.open "D:\qtp.xls"
set sh=xl.activeworkbook.worksheets("Sheet1")
row=sh.UsedRange.rows.count
col=sh.UsedRange.columns.count
for i=2 to row
for j=1 to col
Browser("EMI Calculator").Page("Indiabulls Financial Services").WebEdit("loan-amt").Set sh.cells(i,j)
j=j+1
Browser("EMI Calculator").Page("Indiabulls Financial Services").WebList("period").Set "sh.cells(i,j)"
Next
Next
xl.application.quit
set xl=nothing