How to populate data in weblist using excel - Printable Version

Micro Focus QTP (UFT) Forums

How to populate data in weblist using excel - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: How to populate data in weblist using excel (/Thread-How-to-populate-data-in-weblist-using-excel)

How to populate data in weblist using excel - vijifun - 12-05-2013

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

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

RE: How to populate data in weblist using excel - basanth27 - 12-05-2013

Shouldn't the method be "Select" for a Weblist?