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]
Re: Unable to import data into local sheet
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]
Re: Unable to import data into local sheet
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
Re: Unable to import data into local sheet
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]
Re: Unable to import data into local sheet
hai friends,
Syntax of the import sheet
[B]This is the syntax
Datatable.ImportSheet FileName.vtSrcSheet,VDstSheet[/B]
Thanks
Deepa
Re: Unable to import data into local sheet
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]