SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Oct 2009
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Lightbulb Fech row number from excel using adodb

    Hi,

    Here I am trying to fetch the row num where my actual is equals to 'Secnario_003' in TESTCASENO column from sheet 'TestCases'. it's giving error. is any alternative way to fetch the row num on give value.
    or any query which return the row number on given input

    strConStr = "DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" & PathFinder.Locate("SearchProd.xlsx") & ";readonly=0,autocommit=True,autosave=True"

    Set oObjDB = CreateObject("ADODB.Connection")
    oObjDB.Open strConStr

    Set oObjRS = oObjDB.Execute("SELECT TESTCASENO FROM [TestCases$]")
    row = oObjRS.Find("TESTCASENO LIKE 'Secnario_003'", 0, adSearchForward, adBookmarkFirst)

  2. #2
    Apprentice
    Join Date
    Jan 2008
    Location
    PUNE, INDIA
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Did you try as below?

    iKeywordRow = oObjRS.Find(Trim(sKeyword)).Row

    Ursvardhan
    Automation Testing

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 09:44 PM.

Copyright BetaSoft Inc.