Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to populate data in weblist using excel
#1
Not Solved
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
Reply
#2
Not Solved
Shouldn't the method be "Select" for a Weblist?
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Webtable objects recognise as weblist in UFT 12.5 Sharad Kumar 0 1,171 12-06-2018, 04:57 PM
Last Post: Sharad Kumar
  Search and import data from excel under some rules. nwpulele 2 2,929 02-19-2015, 04:10 AM
Last Post: supputuri
  QTP identifying WebList as WebEdit and an Element passion77 3 8,444 01-27-2014, 10:21 PM
Last Post: supputuri
  Does QTP support writing runtime data to multiple sheets in excel Shwethareddy 2 3,683 10-16-2012, 12:20 PM
Last Post: Shwethareddy
  Cast Excel Data into a 2-D Array ravi.gajul 0 2,562 06-20-2012, 03:07 PM
Last Post: ravi.gajul

Forum Jump:


Users browsing this thread: 1 Guest(s)