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)



Hi,All How to change background color of a cell in excel using qtp and that too with out using Ex..

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

Post New Answer

More QTP Interview Questions

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

1 Answers  


What is keyword driven framework?

0 Answers  


What are the different attributes used with regular expression?

0 Answers  


How u connect bugzilla with QTP

1 Answers   Deloitte, TCS, Wipro,


what are the attributes of QTP?

3 Answers  






How many types of run modes are there in qtp?

0 Answers  


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

2 Answers   IBM,


how i can delete the excel process for the task manager using QTP

2 Answers  


How did you use regular expressions in QTP and also in WR?

0 Answers  


what is Supplemental Objects ?

0 Answers  


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.

1 Answers  


Categories