My Requirement is to color the particular rows in excel sheet with a color
so that it can differenciate the iteration by color
Code used :
objBExcel.Rows(intRowTot).colorIndex = 48
objBExcel.Rows(intRowTot).pattern = xlSolid
This gives me amn error that the method is not supported by the object
tried the code this one too
objBExcel.Rows(intRowTot:intRowTot).colorIndex = 48
objBExcel.Rows(intRowTot).Interior.ColorIndex = 1
-- Here to Learn and share ---
Thanks Jonty it is working
Is there a way to color a particular row during run time?
Here is my example:
DataTable.ImportSheet "C:\Temp\1.xls", "Global", "Global"
rowCount = DataTable.GetSheet("Global").GetRowCount
For i = 1 to rowCount
strComments = trim(DataTable("Comments","Global"))
If (strComments <> "") Then
'HOw to color this row?
Thank you in advance.
No way to do that through QTP DataTable