Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help about write color text by QTP in Excel
#1
Not Solved Shy 
Example i have 2 columns in Excel and have data in 2 columns and compare strings between 2 columns and String in Column A is not equal String in Column B.How can I write color text in Column A by QTP.Please help me .Thanks all much!!!Smile
Reply
#2
Not Solved
U can highlight the cell with the color filled in that, cretae a object of the worksheet like
Code:
set c=obj_worksheet.usedrange.Find(Text u want to search)
For each c in obj_worksheet.usedrange
    If c=Text u want to search Then
        c.Interior.ColorIndex=40
    End If
    Set c=obj_worksheet.usedrange.FindNext(c)

Next

Hope this will help u.

Regards,
Sankalp
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to write reports from scripts into excel anushreebehura 1 2,052 10-04-2016, 09:29 PM
Last Post: venkatesh9032
  Read text from text file and save it into a variable in qtp arpan 3 12,016 06-19-2013, 08:34 PM
Last Post: arpan
MyBB Is it possible to select JTree leafs by it's icon color? KUMAD 0 2,074 05-16-2013, 07:00 AM
Last Post: KUMAD
  Verify Text box border color qtpexpert 3 5,682 09-11-2012, 11:48 PM
Last Post: DevilkID
  Need to compare two text files - ignoring some text nelly27281 2 4,346 09-09-2012, 12:09 PM
Last Post: freeboynil

Forum Jump:


Users browsing this thread: 1 Guest(s)