SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    May 2010
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    QTP works with Excel

    Hi Guys,

    I am working Excel.application in QTP. But the time is too limited for me to learn it step by step. In QTP help, it is very abstract and rough. So does anybody here has the study materials about this?

    It is appreciated that you also can provide the sample codes.

    Thank you in advance!

  2. #2
    Advanced Member venu.adhikesevan's Avatar
    Join Date
    Jun 2010
    Posts
    517
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: QTP works with Excel

    Hi there you can find lot of things about Excel and datatable in QTP manual, if you are not then try with some online tutorials. Here are some codes

    To search certain data in excel

    strfilename = "\Administrator.xls"
    vTestData = "Data need to find in Excel"
    Const xlWhole = 1
    iRow = 0
    Set fso = CreateObject("Excel.Application")
    Set xlBook = fso.Workbooks.Open (strfilename)
    Set xlSheet = xlBook.WorkSheets(2)
    On error resume next
    iRow = xlSheet.Range("A1:A553,B1:B553,C1:C553").Find(vTes tData,,,xlWhole).Row
    If iRow then
    Print "Text found"
    else
    Print "Text not Found"
    EndIf
    Venu
    Today is always better than Tomorrow
    My Blog
    My LinkedIn

  3. #3
    Member
    Join Date
    May 2010
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: QTP works with Excel

    thank you to response my question.

    the help of excel and datatable in QTP manual is quite ok for me.

    But for Excel.Application, I only can find some basic concept like how to declare an instance.

    The reference materials like your sample is good for me I think. Thank you again. Mind to give me more information or help links?

  4. #4
    Super Member Jonty's Avatar
    Join Date
    Jan 2007
    Location
    India
    Posts
    1,266
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: QTP works with Excel

    Cheers
    Jonty..
    -- Here to Learn and share ---

 

 

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 10.71%
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 01:38 AM.

Copyright BetaSoft Inc.