SPONSORS:






User Tag List

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

    Taking value from Action1 sheet

    I have a excel sheet in which there are two default sheets - Global and Action1. In global sheet, there is a column 'Alpha' and there three values in this sheet 1,2, and 3 in Alpha1, Alpha2 and Alpha3 column repectively. Similarly there are three values in Action1 sheet. The name of the column in Action1 sheet is 'Beta'. To take the value from 'Alpha' I use the following script:

    Dim abc
    DataTable.SetCurrentRow 2
    abc=DataTable.value("Alpha", Action1)
    msgbox abc

    but if I change 'Alpha' to 'Beta' it still look for the column 'Beta' in global sheet itself. Can you tell me how to take value from 'Action1' sheet? I will be thankful to you.

  2. #2
    Senior Member
    Join Date
    Dec 2006
    Location
    Germany, Dresden
    Posts
    1,536
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Taking value from Action1 sheet

    there was an equal topic a few days ago.......
    (would be great to consultate the handbook and the online help of QTP before posting...)

    to access your action sheet you have to use "dtLocalSheet". see the online help of QTP for working with the sheets included in your script

    if you want to have a look at the action sheet for your Beta Value you have to use

    Dim abc
    DataTable.SetCurrentRow 2
    abc=DataTable.value("Beta", dtLocalSheet)
    msgbox abc
    http://qcmt.pc-polis.de

    de omnibus dubitandum

    For all Questions: Please be sure to take a look at the QTP Manual before posting any Questions, thanks for doing this

 

 

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:42 PM.

Copyright BetaSoft Inc.