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]
       If $oDiv.classname == "jrFieldValue jrValue" Then $array[$n-2][1] =  $oDiv.innertext
Redim $array[$n-1][2]
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

  • Recently Browsing   0 members

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