New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Loop get excel value

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Loop get excel value
bfakruddin Offline
Member
***
Posts: 146
Threads: 50
Joined: Dec 2008
Reputation: 1
#3
Not Solved 04-29-2010, 11:58 AM (This post was last modified: 04-29-2010, 11:58 AM by bfakruddin.)
Hi,

Code:
Dim xl

Set xl=createobject("excel.application")

xl.workbooks.open("Path of xls file")
xl.visible=true

RC=xl.sheets("SheetID").usedrange.rows.count

set xl_A=xl.sheets("SheetID")

for i=1 to RC

    ur_lp=xl_A.cells(i,1).value
    print ur_lp

Next

set xl=nothing
Find
Reply


Messages In This Thread
Loop get excel value - by gutocruz03 - 04-28-2010, 07:53 PM
RE: Loop get excel value - by basanth27 - 04-29-2010, 11:18 AM
RE: Loop get excel value - by bfakruddin - 04-29-2010, 11:58 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  FOR LOOP shayk1985 1 5,427 12-13-2012, 11:35 AM
Last Post: sams001
  How to exit from a for loop silpavinod 2 10,068 10-17-2012, 12:55 AM
Last Post: agarwl.anurag
  for loop sia sharma 1 3,419 09-13-2012, 11:44 AM
Last Post: ksrikanth2k9
  Help with Loop LJENNE 1 3,269 08-10-2012, 12:32 PM
Last Post: Ankesh
  How to get out of infinite FOR loop... sssidana 3 4,714 07-20-2012, 01:04 AM
Last Post: sree.85

Forum Jump:


Users browsing this thread: 2 Guest(s)