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)
- 1 Answers
- 16325 Views
- I also Faced
- E-Mail Answers
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 |
Does any one worked on JIL Emulator , Testing with QTP(automation). Trail Version of QTP is not identifying the child objects of JIL emulator, Can any one help me out ,
Function to convert lowercase to uppercase in QTP Pls anybody can give the answer.. Thanks in advance...
What is the qtp testing process?
Can objects recognised without repository?
A question was asked in a company-suppose, I am testing a website on QTP, all the time a new title bar is appeared on next page. Trying to use regular expression under key word driven testing but expert view is also appearing unchanged and error is also generating, do you have any best resolution for that kindly explain in detail. please dont give example of yahoomail, that is unable to clear my doubt.
What is output value in QTP? Why do we use the output value in QTP?How many types of output values are there in QTP? what are their respective usage in QTP?
Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?
What are the different types of recording modes in qtp? Which will be used when?
how to post xml data from QTP scripts to any application?
Hi How to retrieve data from web element line by line?
What are the key elements available in test result window?
If you use low level recording,what objects will be recorded in Object Repository and what properties?
WinRunner 
