Array2D and Excel

[tifrice]

Good morning

I try to export Array 2D towards a page Excel, I tried to use the ExcelCOM_UDF bookshop with function " _ExcelWriteArray " but in priori it does not work with pictures in 2D is what anybody would have an idea?

For example here is the function which I have try to use

Func table()

$oFrame = _IEFrameGetCollection($oIE,0)

$oTable = _IETableGetCollection ($oFrame,0)

$oTable1 = _IETableWriteToArray($oTable,1)

$Excel = _ExcelBookNew(1)

_ExcelWriteArray($Excel,1,1,$oTable1,1,1)

EndFunc

[big_daddy]

Can you give an example page? I'm guessing you could modify _ExcelWriteArray to watch for pictures and handle those differently.

[Miau]

I have the same problem, an 2D array i want to export intro exel with the same ExcelCOM_UDF and it's not working, i have error like

C:\kit\date\ExcelCOM_UDF.au3 (542) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

$oExcel.Activesheet.Cells($iStartRow, ($xx - $iIndexBase) + $iStartColumn).Value = $aArray[$xx]

$oExcel.Activesheet.Cells($iStartRow, ($xx - $iIndexBase) + $iStartColumn).Value = ^ ERROR