How Can I use this Syntax?

[NancyNancy]

syntax

Code:

Datatable.ImportSheet FileName.vtSrcSheet,VDstSheet

[BVVPrasad]

Hi,

Here is an example to understand the above syntax:
DataTable.ImportSheet "C:\test.xls",1,"Action1"

"c:\test.xls" - Path of the source excel sheet from which you intend to import data from

1 - First data sheet in test.xls file

"Action1" - Name of the data sheet in the QTP data table.

Thanks,
Prasad

[NancyNancy]

Thanks for getting back to me. One more thing to make things clear, I need to import the data from an excel sheet, into the Global sheet, and save it with the TC. However, when I run that script, it goes into the Global sheet, then Gone after the run is finished. Attached is a DOC with screen shots.