Results 1 to 8 of 8

Thread: Purpose of Global sheet & Action sheet in QTP

  1. #1
    Junior Member
    Join Date
    Oct 2007
    Answers
    27

    Purpose of Global sheet & Action sheet in QTP

    Explain the purpose of Global Sheet and Action Sheet (DataTable) in QTP and the difference between Global sheet and Action1 sheet in QTP.

    Last edited by sridharrganesan; 12-06-2007 at 10:15 AM.

  2. #2
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

    Re: Purpose of Global sheet & Action sheet in QTP

    Hi Ramya,

    An Action Sheet or Local sheet is limited to the associated action only. The scope of data is limited to that particular action. Other Actions which are part of the test cannot access those data values.

    But a Global sheet as the name suggests, has scope with respect to all actions coded as part of a Test. Data values within a Global sheet can be accessed across actions which are part of a single Test.

    To access a particular datavalue from a global sheet we could write -

    Val = DataTable("ParamName", dtGlobalSheet)

    Cheers.....


  3. #3
    Contributing Member
    Join Date
    Nov 2006
    Answers
    76

    Re: Purpose of Global sheet & Action sheet in QTP

    Global Sheet is used for Global use, that means what you
    entered in global sheet that should be used in any action
    in the Test for example: test1 having 4action. at that
    time you want to parameterize the some object in all
    actions with same Test Data. at this times used global sheet

    Action Sheet is used for local use, that means if you want
    to parameterize the actions individually with independent
    test data in test, at that time we are use Action Sheet


  4. #4
    Junior Member
    Join Date
    May 2008
    Answers
    2

    Re: Purpose of Global sheet & Action sheet in QTP

    hi this mahesh

    i ant wat is diff b/w global sheet and action sheet?


  5. #5
    Junior Member
    Join Date
    May 2008
    Answers
    2

    Re: Purpose of Global sheet & Action sheet in QTP

    how to exports the QTP result into Ecellsheet ?


  6. #6
    Junior Member
    Join Date
    Jun 2009
    Answers
    1

    Re: Purpose of Global sheet & Action sheet in QTP

    [QUOTE=mahesh.nuz;29624]hi this mahesh

    i want wat is diff b/w global sheet and action sheet?

    The data in the Global sheet will be shared by all the actions in your test,
    ie., same data will be used by all the actions

    Whereas, the data in the local sheet( action sheet) will be sahred by only one particular action
    ie, every action will have its own set of data

    cheers,
    RAVI


  7. #7
    Expert Member
    Join Date
    Apr 2008
    Answers
    1,859

    Re: Purpose of Global sheet & Action sheet in QTP

    Quote Originally Posted by mahesh.nuz View Post
    how to exports the QTP result into Ecellsheet ?
    Need clarification you need to export results to excel sheet else Data present in the datatable.

    Datatable.Export "C:\Test1.xls"

    Thanks
    Deepa


  8. #8
    Junior Member
    Join Date
    Jul 2009
    Answers
    4

    Re: Purpose of Global sheet & Action sheet in QTP

    Global Sheet is common to all actions in a Test and controls iterations over Test.

    Action Sheet is local to action and is used to control the iterations for the local action and parameterization for local actions.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact