Using Ie.au3 With Excelcom.au3 Question

[litlmike]

I want to take a table from a webpage, and write it into Excel.

For this purpose let's use this webpage:

http://pda.hko.gov.hk/wxreporte.htm, and take the table from there into Excel.

I can get the first column to work, but not the second.

Below that is the code I am using.

Thanks in advance.

expandcollapse popup

#include <IE.au3>; Include the UDF
#include <ExcelCom.au3>

; Create an IE Browser

$oIE = _IECreate()

; Navigate to your URL
_IENavigate($oIE, "http://pda.hko.gov.hk/wxreporte.htm")

; Get a reference to the Second table on the webpage (where the detail is stored)
;    note that object indexes are 0-based, so the second table is index 1
;
$oTable2 = _IETableGetObjByIndex($oIE, 1)

; Read the table cells into a 2-D array
;
$aWeather = _IETableWriteToArray($oTable2)

; Write the array contents out to an .xls
$FilePath = @ScriptDir & "\Test.xls"
_XLCreateBlank($FilePath)


;Confuse myself
;$rows = UBound($aWeather)
;$cols = UBound($aWeather, 2)
;$dims = UBound($aWeather, 0)

$rows_num = 1
For $i = 0 to Ubound($aWeather, 2) - 1
    _XLWrite($FilePath, 1, "A", $rows_num, $aWeather[0][$i], "Visible")
    $rows_num = $rows_num + 1
Next

$cols_num = 1
For $i = 0 to Ubound($aWeather, 2) - 1
    _XLWrite($FilePath, 1, "A", $cols_num, $aWeather[0][$i], "Visible")
    $cols_num = $cols_num + 1
Next

;~ For $i = 0 to Ubound($aWeather, 2) - 1
;~   _XLWrite($FilePath, 1, "A", $dims, $aWeather[0][$i], "Visible")
;~ Next

[DaleHohm]

Have you examined the contents of the array to see if your trouble is with the capture of the data into the array or the writing of the array contents to Excel?

Dale

[litlmike]

Have you examined the contents of the array to see if your trouble is with the capture of the data into the array or the writing of the array contents to Excel?

Dale

Hi Dale. Actually no, I just assumed the capture of the data into the array was correct, since I just took this from your example in IE.au3. Hehe. I assumed the problem was with writing to Excel.

I tried running the example you have in IE.au3 for _IETableWriteToArray(), but it doesn't seem to ConsoleWrite (whatever that is), and so I really don't know how to test that the data. In that, I am not sure how _IETableWriteToArray() actually captures the data. In that, is it 2-dimensional? I remember in IE.au3 it said:

_IETableWriteToArray()

Reads the contents of a table into an array.

Note: Currently, if any of the cells span more than one column, the column offsets will be incorrect

I don't expect anyone to do the work for me, but can you give me some more direction? Thanks!

[DaleHohm]

_IETableWriteToArray() writes all rows and columns into a 2-D array.

ConsoleWrite works well if you are using SciTe as your text editor (highly recommended by the way -- see the downloads page). It writes messages to a special resizable window at the bottom of the editor.

Dale

[litlmike]

_IETableWriteToArray() writes all rows and columns into a 2-D array.

ConsoleWrite works well if you are using SciTe as your text editor (highly recommended by the way -- see the downloads page). It writes messages to a special resizable window at the bottom of the editor.

Dale

Ahh, I was wondering where the output for ConsoleWrite was going! Yes I do use Scite. Thanks for the info.