How can we open an Excel sheet through the script
Answer Posted / bhaskar pothuri
This question is related to automation. As an example we
can open an excel sheet in QTP using the library functions
available in the VB scripting.
| Is This Answer Correct ? | 9 Yes | 16 No |
Post New Answer View All Answers
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
what r the main attributes of test automation?
Explain the qtp test phases.
Hi Guys, I want to place all of my values which i am getting it from a loop in to a global shee. For that i had written the script like this For i = 1 to ECOs-1 ECO = List(i).GetROProperty("innertext") DataTable.AddSheet("ECOList") DataTable.GetSheet("ECOList").AddParameter "ECOList",ECO AbortECO = DataTable.GetSheet("ECOList").GetParameter ("ECOList").Value msgbox AbortECO DataTable.GetSheet("ECOList").SetNextRow Using the above script, whenever the loop iterates it is creating new column "ECOLIST" in the sheet called "ECOLIST". It means, the values are displaying in the column wise even though i added the script " DataTable.GetSheet("ECOList").SetNextRow" . The cursor is not moving to the next line. Anybody help me out how to pass the values from script to the excel(Global/Local) sheet. Pls let me know @ nbabu11@gmail.com if you are not clear about the question.
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?
What are the different attributes used with regular expression?
Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
What are the benefits of qtp?
How do you delete unwanted results in qtp?
In qtp, explain what is crypt object
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
I have 5 save buttons in 5 tabs . The tabs are placed one after the other. My object repository have these added as 5 save buttons with name sav1, save 2, save 3 , save 4, save 5 .all are getting highlighted from OR but they are not getting clicked. After spying each button all the properties are same except First button Index 0 html id:=btnSaveTab1 outerhtml:=", Second button "html id:=btnSave "outerhtml:=", Third button "html id:=", outerhtml:=",
how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods
How many add-ins comes by default with qtp?