Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hi All,

I'm Akshaya here, could anybody please help me regarding
how to import the excel sheet to run time datatable. But
Pl. keep it in your knowledge is that excel sheet is opened.

Thanks,

Akshaya Madali
9823213538

Answers were Sorted based on User's Feedback



Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / sanu

It is not possible to import one excel sheet when it is
open. u should close it b4 try to do the same.

Is This Answer Correct ?    5 Yes 0 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / thirupathi ganguly

Hi Akshaya,

This is Thirupathi,iam working on QTP regarding your
question iam sending you answer
If any questions on QTP Call me on my mobile NO. 9922019467

DataTable.ImportSheet "C:\Test1.XLs" 1,1

1- is Destination Sheet ID( to Data Table)
1- is Source sheet id ( from Excel Sheet)

Regards,
Thirupathi Ganguly

Is This Answer Correct ?    1 Yes 1 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / suresh

datatable.import "D:\Document and setting\test1.xls"

Is This Answer Correct ?    1 Yes 2 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / siraj

FOR IMPORTING PARTICULAR SHEET FROM THE EXCEL BOOK.
--------------------------------------------------
Datatable.importsheet "D:\test1.xls",1,1

FOR IMPORTING WHOLE EXCEL BOOK(DEFAULT 3 SHEETS)
------------------------------------------------
Datatable.import "D:\test1.xls"

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More QTP Interview Questions

Plz Explain How to access Or Store Script from VSS? Explain Real time work (qtp) where you store folders and next to how to you access that folders and how you maintain folders in VSS ? What are the Menu's in VSS? Suppose in Manual, by using Checkin Checkout u can access documents. how you access in QTp REal time?

0 Answers   CTS,


How to call actions in QTP?

2 Answers   Wipro,


How many scripts do you write per day. What is the average number of scripts you have written in your recent project

1 Answers   CenturyLink, Optum, Value Labs,


dears, I have one question for QTP.If my software is english and defined objects is english name. But, if my software has support MUI, under this case that my objects in the QTP can't work, because the QTP can't catch the objects name. In this case, is anybody know how to solve this problem? Thanks a lot.

2 Answers   CyberLink,


How to call a function in QTP?Is there any method ? Thanks , PRASANNA

2 Answers  


How to execute the test cases using QTP. i.e What is the use of QTP while execution

2 Answers  


Is manual Testing replacement of automation testing?Which types of testing we can not do in automation testing but can do in manual testing?

1 Answers   Hewitt, Wipro,


What is text check point and text area check point?

0 Answers  


How to connect to a database?

0 Answers  


I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?

0 Answers  


What is the difference between Keyword Driven test and Data Driven test?

0 Answers  


Hi All, I am using QTP for one of the Desktop application which uses Keyboard inputs like 'Tab ,F7 etc' and also mouse (Click). After recording when i am running the Script ,it is not able to recognize the keyboard inputs like F7,Tab and mouse Click because of which either i have to skip that part or manually do the inputs. Please answer how can i make script more flexible so that it will recognize both keyboard and mouse operations.

3 Answers  


Categories