Jump to content

Extract IE data to excel using _IE


Recommended Posts

Hello all,

I need to extract data to an excel file.

the data is a web page: http://www.equities.com/hedge-funds/2485-1492-capital-management

i tried to use , _IEGetObjById, and _IEGetObjByname i am getting error code 7 (no match), i used also 

Local $oForm =_IEFrameGetObjByName($oIE, "jrFieldLabel jrLabel") and still getting error code 7 (no match)

 

Thanks for helping !!!

 

Link to comment
Share on other sites

Do you mean something like this ?

#include <IE.au3>
#Include <Array.au3>

$oIE = _IECreate("http://www.equities.com/hedge-funds/2485-1492-capital-management", 0, 0)

Local $array[1][2], $n = 1, $oDivs = _IETagNameGetCollection($oIE, "div")
   For $oDiv In $oDivs
       If $oDiv.classname == "jrFieldLabel jrLabel" Then 
          $array[$n-1][0] = $oDiv.innertext
          $n += 1
          Redim $array[$n][2]
       EndIf
       If $oDiv.classname == "jrFieldValue jrValue" Then $array[$n-2][1] =  $oDiv.innertext
   Next
Redim $array[$n-1][2]
_ArrayDisplay($array)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...