Did that work for you?

Did that work for you?

If you want to get the items in the ValueList for a particular cell try something like this:

Sub GetValueListData()

Dim ItemCount
ItemCount = SwfWindow("Company").SwfTable("Grid").GetNaProperty("DisplayLayout.Bands[1].Columns[4].ValueList.Rows.Count")

MyData = ""

For i = 0 to ItemCount -1 step 1
MyData = MyData & SwfWindow("Company").SwfTable("Grid").GetNaProperty("DisplayLayout.Bands[1].Columns[4].ValueList.Rows[" & i & "].Cells[1].Text") & vbCrLf
Next

MsgBox MyData
End Sub

GetValueListData()

If you just want to get the value from a cell in a child row you can do something like this:

MyData = MyData & vbCrLf & SwfWindow("Company").SwfTable("Grid").GetCellData("0;1","Color")

Let me know if that works for you.

I am using this and this works

 Sub GetCellData_Example1()
                    'The following example uses the GetCellData method with Infragistics UltraWinGrid control      to                 return the data  'contained in the second row of the "Description" column within the second band level.

MyData =SwfWindow("EMT").SwfWindow("EMTReinsurance").SwfTable("ugAviLayers").GetCellData("0;0","PolicyRef")
MsgBox MyData
End Sub

Call GetCellData_Example1()

But i want to get the cell data at run time by using getrow count and column count but i have two bands.

how can i make that work ????

Dennis,

Your approach should work fine.

Let me know if you have any questions with this matter.

Alan