Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Unable to import data into local sheet
This is a discussion on Unable to import data into local sheet within the QTP forums, part of the Software Testing category; 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 ...
|
|||||||
07-31-2007
|
|||
|
|||
|
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 
|
| Sponsored Links |
|
07-31-2007
|
|||
|
|||
|
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,"Action1"
|
|
05-26-2009
|
|||
|
|||
|
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
|
|
05-27-2009
|
|||
|
|||
|
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:
|
|
05-27-2009
|
|||
|
|||
|
Re: Unable to import data into local sheet
hai friends,
Syntax of the import sheet This is the syntax Datatable.ImportSheet FileName.vtSrcSheet,VDstSheet Thanks Deepa
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| reading data from excel sheet in QTP | JobHelper | QTP | 12 | 3 Weeks Ago 09:46 AM |
| Geting data from odd rows of an excel sheet, | JobHelper | WinRunner | 2 | 10-18-2007 07:17 AM |
| How to design and use the data sheet in a Script | sudhakartrk | QTP | 1 | 07-10-2007 02:51 PM |
| Code for getting data from excel sheet | JobHelper | WinRunner | 0 | 12-20-2006 07:08 PM |
| Microsoft CRM : 5 ways to import data | Jim.Anderson | Microsoft CRM | 0 | 09-27-2006 07:39 AM |
All times are GMT -4. The time now is 06:17 PM.
