How open an excel sheet in QTP(not a run time )?
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 is an Custom Object in QTP ?
Plz explain about object propeties in object identification? means.. explain about 1. mandatory properties.2. assestive properties 3. ordinal properties.
How to Start recording using QTP?
what is the main process in QTP?
Explain the concept of how QTP identifies object.
On what basis we select test cases to automate?
what type of run time errors you get while you ar edoing rpg program?
What are the challenges you faced during you entire life automation ?
1>why parameterization is necessary in qtp? 2>if we give constant value then what problem?
How do you perform Regreession Testing?
Where we write the FUNCTIONS, in Expert view (or) in any textfiles like Notepad and save it in Library functions folder? How to cal that functions to our script? How to save that functions to Function generator?
i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet