Can you import and export data from XLS and how?
- 4 Answers
- 6312 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uday kumar_anem
We can import or export the data from Excel sheet in 2 ways.
1. by using Datatable.import("ExcelFile")
Datatable.export("ExcelFile")
2 Place your mouse over datatable in QTP and right click ->
File -> Import File /Export
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dixit
her i want to add some thing
if you want to import particular sheet then you can use
ImportSheet method
DataTabe.ImportSheet("path of Excel",Source Sheet,Dest
Sheet)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramu@sunnys
yes,we use datatable.import for import data and
datatable.export for export the data
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ramu@sunnys
yes,we use datatable.import for import data and
datatable.export for export the data
| Is This Answer Correct ? | 0 Yes | 2 No |
Explain the concept of object repository & how QTP recognises objects?
can any one explain with an example how to test Web application using qtp
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object.. (give a filter condition only WEbelement- not easy need to use some more property while giving filter condtions- use google for your help...))
How to load a object repository(using VBScript) ... very urgent....
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
Hi, I have a login page. To login in that page I need to have a valid username and password, which is stored in database. I imported that table to my DataTable in QTP (Global sheet). Now I need to write a code in qtp so that I can login only with valid username and data. my condition is : I want to get username and password from inputbox(which i did) and click on login button- which should verify the datatable for username and password and if value is present only then lofin else stop the testing. DataTable contains columns : LoginName and Password Code: Rowcount= DataTable.GetSheet("Global").GetRowCount msgbox "RowCount= " &RowCount,1 CurrentRow= DataTable.SetCurrentRow(1) Do Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$UserName$ctl").Set DataTable("LoginName",1) Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$Password$ctl").Set DataTable("Password",1) Browser("").Page("").Frame("Frame").Link("Login").Cli ck CurrentRow=CurrentRow+1 Loop Until CurrentRow>Rowcount Can anyone help? Thanks, Priya
what is check point?
what is run-time data?
Why do we use text checkpoint as we can make use of the same in the standard check point?
What are the details steps to connect a remote mysql database in QTP
Can you import and export data from XLS and how?
HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com
WinRunner 
