Hi,All
How to change background color of a cell in excel using qtp
and that too with out using Excel Object.(I am importing
the excel sheet by using ImportSheet method)
Answer / srinivasa reddy m
Set oExcel = Createobject("Excel.application")
oExcel.Visible = True
Set oWorkBook = oExcel.WorkBooks.Open("c:\Book1.xls")
Set oWorkSheet = oWorkBook.WorkSheets(1)
oWorkSheet.Cells(1,1).Interior.ColorIndex = 38
Is This Answer Correct ? | 15 Yes | 6 No |
I have 5 save buttons in my application on 5 different tabs one after the another . I have spy them and added each of them in my OR. My Or is able to highlight each button on each of the 5 tabs. But when I run the script it does not click the object.Is there anything I have to edit in OR. Any property to add or delete? Below are the properties of 5 save buttons. My code for each is like browser().page().savebutton1.click Browser().page.savebutton2.click Properties of 5 buttons Dhopare, Namita Sent: September 2, 2015 2:57 PM To: Vullengala, Jagadeeshchandra "Class Name:=WebButton", "abs_x:=718", "abs_y:=693", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSaveTab1", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=718", "y:=616" "Class Name:=WebButton", "abs_x:=687", "abs_y:=571", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSave", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=687", "y:=494" "Class Name:=WebButton", "abs_x:=635", "abs_y:=478", "class:=Button", "disabled:=0", "height:=23", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a3').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=635", "y:=401" "Class Name:=WebButton", "abs_x:=695", "abs_y:=558", "class:=Button", "disabled:=0", "height:=22", "html id:=BtnExternalPartySve", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""BtnExternalPartySve"" class=""Button"" onclick=""document.getElementById('a4').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=695", "y:=481" "Class Name:=WebButton", "abs_x:=672", "abs_y:=642", "class:=Button", "disabled:=0", "height:=22", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=672", "y:=565" Previous Item Next Item Connected to Microsoft Exchange
What is keyword driven framework?
What are the different attributes used with regular expression?
How u connect bugzilla with QTP
1 Answers Deloitte, TCS, Wipro,
what are the attributes of QTP?
How many types of run modes are there in qtp?
how to count the word "IS" is repeated in the application using DP
3 Answers DST Global Solutions,
In Keyword driven frame work you have write 30 test case for one scenario,in which 10 test cases are failed while executing.client asked you to execute only the failed test cases. HOw can you execute only failed test cases
how i can delete the excel process for the task manager using QTP
How did you use regular expressions in QTP and also in WR?
what is Supplemental Objects ?
what are the settings to be done to make the recovery scenario created for one test to be used bye all the other tests. please tell me recovery scenario process in detail.