07-20-2010, 10:23 AM
Try this:
for row and cols count.
And loop through the counts(rows and cols), to fetch the cell data and debug through to find the what is the row number and column number for the cell for which you know the expected data.
Is it clear to you?
Ex:
Code:
Tcount.GetROProperty("rows") and Tcount.GetROProperty("cols")
And loop through the counts(rows and cols), to fetch the cell data and debug through to find the what is the row number and column number for the cell for which you know the expected data.
Is it clear to you?
Ex:
Code:
a = Tcount.GetROProperty("rows")
b = Tcount.GetROProperty("cols")
For i = 1 to a
For j = 1 to b
c = Tcount.GetCellData(i,j)
msgbox c 'here you should be able to see what each cell has data in that table.
Next j
Next i