Jump to content
Sign in to follow this  
avidovi

Extract IE data to excel using _IE

Recommended Posts

avidovi

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 !!!

 

Share this post


Link to post
Share on other sites
mikell

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)
  • Like 1

Share this post


Link to post
Share on other sites
avidovi

You are a champ my friend

Thank you very much!!!!! :)

Share this post


Link to post
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
Sign in to follow this  

×