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

Question asked by visitor venkateshwarrao

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

DataTable.ImportSheet "path of the excel file" ,1,"Action1"

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

Originally Posted by deepasree

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

hai friends,

Syntax of the import sheet

This is the syntax
Datatable.ImportSheet FileName.vtSrcSheet,VDstSheet

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 !

Originally Posted by Geek_Guest

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

Question asked by visitor venkateshwarrao