_IETableWriteToArray - medley works

[AlexVong]

Very slow _IETableWriteToArray

#include

#include



;no check errors



$sUrl = @ScriptDir & '\test.htm'

$oIE = _IECreate($sUrl)

$oTable = _IETableGetCollection($oIE, 3)

$aTable = _IETableWriteToArray($oTable, True)

_IEQuit($oIE)

$oExcel = _ExcelBookNew()

_ExcelWriteSheetFromArray($oExcel, $aTable, 1, 1, 0, 0)

_ExcelBookSaveAs($oExcel, @ScriptDir & '\Test.xls', 'xls', 0, 1)

_ExcelBookClose($oExcel)

Table 30 000 - 50 000 lines

What alternative?

[Andreik]

Well, AutoIt loops are slow and this function use a lot of loops. The alternative it's to try access data directly from table object without put it into an array.

Edit: typo error

Edited November 16, 2012 by Andreik

[sleep365]

yes ,it just very slow ,you can use StringRegExp Function to get cell,you can try the code .

$sText = _IEDocReadHTML($oIE)
$aTableData = StringRegExp($sText,'(?<=>)[^<v"]+(?=<)',3)
_ArrayDisplay($aTableData)

Edited November 16, 2012 by sleep365

[AlexVong]

Example....

table.htm

[sleep365]

#include <IE.au3>
#include <Array.au3>
$sUrl = @ScriptDir & '\table.htm'
$oIE = _IECreate($sUrl)
_IELoadWait($oIE)
$htmltxt = _IEBodyReadHTML ( $oIE )
MsgBox(0,'t0',$htmltxt)
$aTableData = StringRegExp($htmltxt,'(?<=>)[^<\v"]+(?=<)',3)
_ArrayDisplay($aTableData)

I use the code ,get the result.

Edited November 20, 2012 by sleep365