Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GetRowWithCellText does not work if the header has a colspan
#6
Solved: 10 Years, 10 Months ago
ConstantChange, you can also try this (a little simple and configurable):

Code:
Public Function getTargetRow(sText)

    Set oTable = Browser("micclass:=Browser").Page("micclass:=Page").WebTable("")
    rowTotal = oTable.GetROProperty("rows")
    colTotal = oTable.GetROProperty("cols")
    For rowStart = 1 to rowTotal
        For colStart = 1 to colTotal
            sData = ColInfoTable.GetCellData(rowStart,colStart)
            If sData = sText Then
                getTargetRow = rowStart
                Exit Function
            End If
        Next
    Next

End Function
Reply


Messages In This Thread
RE: GetRowWithCellText does not work if the header has a colspan - by Anshoo Arora - 05-10-2008, 05:34 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Set the column header in the excelsheet before importing it to local datasheet nageshpv 2 3,230 08-04-2008, 04:05 PM
Last Post: nageshpv

Forum Jump:


Users browsing this thread: 1 Guest(s)