Unable to import data into local sheet

Hello everybody,

I am new to automation, in learning stage. I have a small doubt. I wrote script for importing data from excel sheet to the datatable as follows:

DataTable.ImportSheet "path of the excel file" ,1,GlobalThis is working fine.
QTP is able to import data. But when i am trying to import the data into Local sheet i am unable to do that. Even if I change script the following way, i am not able to do: DataTable.ImportSheet "path of the excel file" ,1,Local ORDataTable.ImportSheet "path of the excel file" ,1,Action1

Please help me in this regard

[B]Question asked by visitor venkateshwarrao[/b]

Hey try this and see..u missed the dbl quotes

DataTable.ImportSheet "path of the excel file" ,1,[COLOR="Red"]"[/COLOR]Action1[COLOR="red"]"[/COLOR]

hai friend,

Its very easy

DataTable.ImportSheet "C:\Documents and Settings\Deepa\Desktop\Abc.xls",2,1

It will import the data present in the ABC. excel sheet in to the local sheet

Thanks
Deepa

Hi

do a small change in the Deepa's code and use it, it will work.

Datatable.ImportSheet "C:\Documents and Settings\Deepa\Desktop\ABC.xls",1,2

MANI


[QUOTE=deepasree;45029]hai friend,

Its very easy

DataTable.ImportSheet "C:\Documents and Settings\Deepa\Desktop\Abc.xls",2,1

It will import the data present in the ABC. excel sheet in to the local sheet

Thanks
Deepa[/QUOTE]

hai friends,

Syntax of the import sheet

[B]This is the syntax
Datatable.ImportSheet FileName.vtSrcSheet,VDstSheet[/B]

Thanks
Deepa

I hope you can read this soon.

Can you help me, I am having trouble importing the Excel into QTP

Impot happens, but does not stay. Once test is complete, everything goes away !

[QUOTE=Geek_Guest;15975]Hello everybody,

I am new to automation, in learning stage. I have a small doubt. I wrote script for importing data from excel sheet to the datatable as follows:

DataTable.ImportSheet "path of the excel file" ,1,GlobalThis is working fine.
QTP is able to import data. But when i am trying to import the data into Local sheet i am unable to do that. Even if I change script the following way, i am not able to do: DataTable.ImportSheet "path of the excel file" ,1,Local ORDataTable.ImportSheet "path of the excel file" ,1,Action1

Please help me in this regard

[B]Question asked by visitor venkateshwarrao[/b][/QUOTE]