Error from function _IETableWriteToArray

[Jess]

Hi,

I am trying to fetch table data from website and display the array. but, it is showing an error  "Error from function _IETableWriteToArray, $_IESTATUS_InvalidDataType".

Please help in the same case.

Thanks 

[Jess]

Hi,

I am trying to do the same thing with some website, but it is always throwing an error as below.

--> IE.au3 T3.0-2 Warning from function _IETableGetCollection, $_IESTATUS_NoMatch
--> IE.au3 T3.0-2 Error from function _IETableWriteToArray, $_IESTATUS_InvalidDataType

Please can anyone help in this case, as I have tried all the solutions provided above.

[Danp2]

@Jess Your issue is different that this earlier thread. For best results, please repost your issue in a new thread and be sure to include your code so that we can hopefully assist you.

[Danp2]

Post your code.

[Jess]

@Danp2 I have already posted my issue in a new thread. The link is as follows

 https://www.autoitscript.com/forum/topic/189997-error-from-function-_ietablewritetoarray/#comment-1363971

 

thanks

[Jess]

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

_IEErrorHandlerRegister(MyErrFunc)
Global $oMyError = ObjEvent("AutoIt.Error","MyErrFunc")    ; Initialize a COM error handler
; This is my custom defined error handler
Func MyErrFunc()
  Msgbox(0,"AutoItCOM Test","We intercepted a COM Error !"    & @CRLF  & @CRLF & _
             "err.description is: " & @TAB & $oMyError.description  & @CRLF & _
             "err.windescription:"   & @TAB & $oMyError.windescription & @CRLF & _
             "err.number is: "       & @TAB & hex($oMyError.number,8)  & @CRLF & _
             "err.lastdllerror is: "   & @TAB & $oMyError.lastdllerror   & @CRLF & _
             "err.scriptline is: "   & @TAB & $oMyError.scriptline   & @CRLF & _
             "err.source is: "       & @TAB & $oMyError.source       & @CRLF & _
             "err.helpfile is: "       & @TAB & $oMyError.helpfile     & @CRLF & _
             "err.helpcontext is: " & @TAB & $oMyError.helpcontext _
            )
Endfunc
;_IEErrorNotify(False)

;$iWait = 0
$oIE = _IECreate("https://cmooc.cognizant.com",0,1,0,0)
MsgBox(0,"_IECreate", @error)
Sleep(3000)
$oTable = _IETableGetCollection ($oIE,0)
;MsgBox(0,"Object",IsObj($oTable))
MsgBox(0,"_IETableGetCollection", @error)
$aTableData = _IETableWriteToArray ($oTable)
MsgBox(0,"_IETableWriteToArray", @error)
$iNumTables = @extended


MsgBox(0, "Table Info", "There are " & $iNumTables & " tables on the page")
_ArrayDisplay($aTableData)

Here it is. 

[Danp2]

This code runs fine for me --

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

_IEErrorHandlerRegister(MyErrFunc)
Global $oMyError = ObjEvent("AutoIt.Error","MyErrFunc")    ; Initialize a COM error handler
; This is my custom defined error handler
Func MyErrFunc()
  Msgbox(0,"AutoItCOM Test","We intercepted a COM Error !"    & @CRLF  & @CRLF & _
             "err.description is: " & @TAB & $oMyError.description  & @CRLF & _
             "err.windescription:"   & @TAB & $oMyError.windescription & @CRLF & _
             "err.number is: "       & @TAB & hex($oMyError.number,8)  & @CRLF & _
             "err.lastdllerror is: "   & @TAB & $oMyError.lastdllerror   & @CRLF & _
             "err.scriptline is: "   & @TAB & $oMyError.scriptline   & @CRLF & _
             "err.source is: "       & @TAB & $oMyError.source       & @CRLF & _
             "err.helpfile is: "       & @TAB & $oMyError.helpfile     & @CRLF & _
             "err.helpcontext is: " & @TAB & $oMyError.helpcontext _
            )
Endfunc
;_IEErrorNotify(False)

;$iWait = 0
$oIE = _IECreate("https://cmooc.cognizant.com")
$oTable = _IETableGetCollection ($oIE,0)
$iNumTables = @extended
$aTableData = _IETableWriteToArray ($oTable)


MsgBox(0, "Table Info", "There are " & $iNumTables & " tables on the page")
_ArrayDisplay($aTableData)

Note the placement of the line that checks @extended. Had to move this so that it captures the value at the proper time.

If you are still having issues, please post the full results from the Scite output window.

[BrewManNH]

8 hours ago, Jess said:

I have already posted my issue in a new thread.

So why did you post in this thread?

[Jos]

Merged the posts from the "Other" thread where they didn't belong, Please stick to one thread and no cross posting the same question!

Jos

[Jess]

Hi @Jos @BrewManNH,

I had posted my query in a new thread and after that I saw this thread. So, posted here. sorry for that.

And I had posted my code in the thread I started. I think it got merged or by mistake.

 

Thanks for your help.

[Jess]

Hi @Danp2

 

The code is still showing the same error for me. Is it something with the version or OS that I am working in.

 

thanks

[Danp2]

22 hours ago, Danp2 said:

If you are still having issues, please post the full results from the Scite output window.

@Jess Please do the above. Also, it helps when you can provide details when you respond. Telling us "Is it something with the version or OS that I am working in" doesn't really move the conversation along. What version of AutoIT are you running? What is your OS? Etc.