Interested to Buy Any Domain ? << Click Here >> for more details...
How open an excel sheet in QTP(not a run time )?
- 4 Answers
- 10520 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / king
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.Worksheets(1).Cells(1,1).Value="Ankush"
ExcelBook.Worksheets(2).Cells(1,1).Value="Raju"
ExcelBook.SaveAs "C:\test1.xls"
ExcelApp.Quit
Set ExcelApp = Nothing
msgbox "Completed"
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / pramod
Hello,
It asked for "not a run time " means "not in run time"
Why do you write all VB script code to open Excel in run
time.
It is simple. Click View - data table in QTP.
Right click on Data table window. Select File - Import.
Select the Excel file. that is it.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / cxv
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.Worksheets(1).Cells(1,1).Value="A"
ExcelBook.Worksheets(2).Cells(1,1).Value="Ra"
ExcelBook.SaveAs "C:\test1.xls"
ExcelApp.Quit
Set ExcelApp = Nothing
msgbox "Completed"
| Is This Answer Correct ? | 1 Yes | 2 No |
how u will describe testing activities?
What is a runtime datatable ?
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
Hi everybody.. I m using QTP 9.2 version., plz send me licence key is it seat or concurrent licence key... plzzzzzzzzz plz help me for this one and its Locking code:8-5C740 Maintenance number: 0123-2820602186.,
Can any give an example(if possible templates) how to test web application using QTP. thanks in advance
what is Function Definition Generator? can any one explain me in details?
What is the difference between run time object and test object in QTP?
Mention the different actions types of qtp.
On the website, the protocol has been changed https: to https what you will do? Tell me your approach?
Question:how many types of repositories in QTP9.2?and explain??
Hi frnds, for ex.. we got a job in wipro, they will give me one mail id.. "Rameshkumar@wipro.com", where to open this mail id..in which sw ? or outlook?
Can I change properties of a test object?
WinRunner 
