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

How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

2 Answers  

I am trying to read the rediffmail usign the below code. But facing problem, while i user to get the link of the mail, i am getting all the link of the page, While i just want to get only mail name - link (not all the link of an page) so that i able to read the mail message by clcking on them in qtp. Dim Lnk,Webcheckbox Set Lnk= Description. Create '********* To count and display the webcheckbox Lnk("micclass" ).value=" Link" set LinkName= Browser("Welcome to Rediffmail:" ).Page("Welcome to Rediffmail:" ).ChildObjects( Lnk) LinkCount=LinkName. Count msgbox LinkCount For i=1-1 to LinkCount-1 DataTable.SetCurren tRow(i) DataTable.Value( "Name",1) =LinkName( i).GetRoProperty ("name") Next Waiting for the reply Praveen Saini

1 Answers  

tell me about framework types and most used framework in real time. types of output value in details. diff between wr and qtp in detail.

2 Answers  

1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?

0 Answers   HP,

Can any one explain about environment variables with examples?

2 Answers  

what area in a web application cannot be automated.

1 Answers  

How to catch the TOol Tip Dyanamically changing values using the qtp script by Descriptive Programming Scenario: ======== 1. when i press the submit button 2. The Tool tip first shows the value "Validating...." 3. Next the value is changed in tooltip "Logging....." ------ And the class is webElement SO , how can i catch both values During Run time using Dp

1 Answers  

Anybody explain me, the concept of checkpoint declaration in the QTP mainly for the Objects, Pages, Text and Tables ?

1 Answers  

what is the Debug view?

1 Answers  

Hello Everybody, Can anyone tell me that in QTP how to count the number of webelements from the object repository. Please provide the code. Thanks in advance, Gaytri

3 Answers  

what r the 3 basic factor on which we determine to perform automation

6 Answers   AppLabs,

what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

0 Answers   Satyam, Intel,