Thread: 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.....

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

hi this mahesh

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

how to exports the QTP result into Ecellsheet ?

[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

Originally Posted by mahesh.nuz

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

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.