Interested to Buy Any Domain ? << Click Here >> for more details...
Can you import and export data from XLS and how?
- 4 Answers
- 8082 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 |
Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?
what is input pramater out output pramater ?i want the decrepation..?how to use in QTP?
3 Answers Infinite Computer Solutions,
How did you resolve conflicts present in Object Repository?
What are the drawbacks of QTP?
what are the areas that cannot be tested using an automated tool? list a few
Hi I am new to QTP. we are planning to implement automation for the application. I am trying to execute the following script: Set ExcelObj=CreateObject ("Excel.Application") ExcelObj.WorkBooks.Add Set NewSheet=ExcelObj.Sheets.Item(1) NewSheet.Name="Order" ExcelObj.Cells(1, 1).Value = "Name" ExcelObj.Cells(1, 2).Value = "Ordernum" ExcelObj.Cells(2, 1).Value = "nam" ExcelObj.Cells(2, 2).Value = "21" ExcelObj.ActiveWorkbook.SaveAs "c:\test1.xls" ExcelObj.Quit Set ExcelObj = Nothing in the above script for the line(ExcelObj.Cells(2, 2).Value = "21") it is inserting the value 21 successfully.this is fine But if i want to insert a variable instead of the constant value then what should be the modification in the script. For example: If user retrives a value throug "GetRoProperty" and wants to insert the value into then how the script changes?
What is CMMP and CMMH?
What is the difference in testing a client-server application and a web application?
Diff b/w Health care domain and Banking Domain?
Find the 'String' from excel sheet and save to another sheet.But we don't know the string column number and row number?
What’s the basic concept of QTP?
Can you give me the code to calculate the total number of Links using the child object in the web page..? is there any other way to calculate number of links with out using the Child objects.??
2 Answers DST Global Solutions,
WinRunner 
