06-30-2011, 09:28 AM
Hi Lorena,
I cannot say why your code is not working as I dont have the application with me. But if you want to get all the items of the webtable then you can use below code:
Always use GetCellData if you want the data from any webtable cell. Use ChildItem method when one cell of webtable contains more than one value and you need index to get the desired value from that cell e.g.
the last column of you webtable which contains 3 links, If you want to click any of these three links then you have to use childitem method.
Regards,
Parminder
I cannot say why your code is not working as I dont have the application with me. But if you want to get all the items of the webtable then you can use below code:
Code:
Set TableObj = Browser("Wisdom").Page("Wisdom IA_2").Frame("parent").WebTable("Select All")
RowCount= TableObj.RowCount
Cols=TableObj.ColumnCount
rNumber = 1
For r = 3 to RowCount
For i=1 to Cols
rNumber = rNumber +1
NumPages = TableObj.GetCellData(r,i)
objExcel.Cells(rNumber, 6).Value = NumPages
Next
Next
Always use GetCellData if you want the data from any webtable cell. Use ChildItem method when one cell of webtable contains more than one value and you need index to get the desired value from that cell e.g.
the last column of you webtable which contains 3 links, If you want to click any of these three links then you have to use childitem method.
Regards,
Parminder