Interested to Buy Any Domain ? << Click Here >> for more details...
How open an excel sheet in QTP(not a run time )?
- 4 Answers
- 10462 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 |
what are the areas that cannot be tested using an automated tool? list a few
How many types of Parameters are available in QTP? and Pls Explain with example.
I have a tool for automation testing (eg:qtp).I have two functionality(A & B) to test.A is tested once in a year. B is tested everyday. At present i have the money and resource availability to automate only one functionality.Which one will u suggest and why?
What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?
Explain the concept of object repository & how qtp recognizes objects?
How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.
what is the frame work your using in automation ?
How smart identification works in qtp ?
How to load the object repository at run time?
How to use the object spy in quicktest professional (qtp) 8.0 version?
how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!
what is virtual object?
WinRunner 
