Forum Discussion

sandhu97's avatar
sandhu97
Occasional Contributor
15 years ago

URJENT !! How to capture values from a table in an excel file?

Hi Eveerybody, I just started using test complete in my new company. I need to captutre values from a web table with diff data feilds. The data from these data fields has to be saved to an excel fi...
YMinaev's avatar
YMinaev
Icon for Staff rankStaff
15 years ago
Hi,



You can use code like this:



' Initialize Excel object here

objArray = Aliases.iexplore.FindAll("property name", "property value", 100)

For i = 0 To UBound(objArray) - 1

xlSht.Cells(i + 1, 1) = objArray(i).innerText

Next

' Save here