Sign Up Login


  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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)

Question Posted / linuskh


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 do we run the scripts in QTP ?? what are the three options....

4 Answers   HCL,

what testing activities u may want to automate in a project?

2 Answers  

What are all the common questions asked for the candidates having more than 1 yrs exp in QTP?

1 Answers  

Can you list some technologies that support qtp?

0 Answers  

How to capture data from images in QTP and produce them in Excel sheet ? please ans...

3 Answers   Sapient,




Explain about the Test Fusion Report of QTP ?

1 Answers   Ordain Solutions,

What is Parameterizing Tests?

4 Answers  

Which features or drawbacks of QTP lead to the upgrade for a newer version?

0 Answers  

I came across Good question ..... Write a script to only download pdf's if there are 20 links on a page. Kindly reply these type of questions are pretty challenging..

4 Answers   Keane India Ltd,

Object Repositories types, which & when to use?

3 Answers   Crea,

what is diffrense between action and function

4 Answers   IBM,

Explain xml checkpoints.

0 Answers  

For more QTP Interview Questions Click Here
Categories