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 Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What environment does qtp run in?

782


Why qtp always start action1 and does not start action?

820


What are the different types of qtp test assets and their extensions?

836


Is it possible to merge two object repository files in qtp?

812


What is the architecture of your project? Can any one answer for this question plz........

1578


Plz Explain AUTOMATION REFERENCE MODEL?

1884


What is the recovery scenario in qtp?

754


• What type of testing questions will be asked for 2+ yrs exp people in interview?

1463


How to call a test from another test?

946


What is the basic concept of quicktest professional (qtp)?

780


what is stepin & stepout?

1602


What is Associate Repository in QTP 9.2 ?

780


What is the use of Debug Viewer?

1658


who QTP recognizes the object stored in object repository?

1851


banking domain description for software tester for interview

3656