Problem in using importing data sheet value and design table value

[praneeth_be]

I have an local action containing three columns and with 10 rows data.Also I have an excel file which contains 5 columns with 5 rows data.So while running the script I am importing the excel file data into the local action.Here importing is happening successfully but my requirement is to use run time data table value and design data table value with out stopping the test.Can you please suggest me in doing this operation(So if we import excel file into the global sheet then we can use both the values i.e., imported global action value and local action value but we are using global sheet for other purpose)

[basanth27]

Why dont you import it to a action ? You can use Globalsheet for your purpose and make use of the action sheet for the import/export. Read through QTP Help to understand about Global and action sheets and their differences.

[Saket]

Add another sheet to your datatable and import the excel data into the new sheet.
You can do this runtime.
use

Code:

DataTable.AddSheet <<Your Sheet Name>>
Datatable.ImportSheet <<Excel file Path>>,<<Source sheet>>,<<Dest Sheet>>

does this solve your issue.