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
What environment does qtp run in?
Why qtp always start action1 and does not start action?
What are the different types of qtp test assets and their extensions?
Is it possible to merge two object repository files in qtp?
What is the architecture of your project? Can any one answer for this question plz........
Plz Explain AUTOMATION REFERENCE MODEL?
What is the recovery scenario in qtp?
• What type of testing questions will be asked for 2+ yrs exp people in interview?
How to call a test from another test?
What is the basic concept of quicktest professional (qtp)?
what is stepin & stepout?
What is Associate Repository in QTP 9.2 ?
What is the use of Debug Viewer?
who QTP recognizes the object stored in object repository?
banking domain description for software tester for interview