Jump to content
Sign in to follow this  
tifrice

Array2D and Excel

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

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  

×
×
  • Create New...