Populating Arrays from Excel

[claycrosby123]

Hi all,
 
I am working on a data entry utility to enter large amounts of data into a piece of software. My data lives in a series of excel spreadsheets each with 6 columns and 100 rows (the software into which I'm entering my data has a limit of 100 rows per entry).
 
I'm having a hard time getting my arrays to populate with data from Excel. Here's what I've got set up:

;; Populate arrays with CDM charge info from excel doc
Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel,@DesktopDir & "\AutoItTest.xlsx")
Sleep(2000)

Local $aProcedure = _Excel_RangeRead($oExcel,Default,$oWorkbook.ActiveSheet.Usedrange.Columns("A:A"),1)

I then repeat this for each of my other 5 columns of data.

Based on the information in Help, I take this to populate my $aProcedure array with all of the contents in column A.

Please help! Thank you!

[JLogan3o13]

This works just fine for me:

#include <Array.au3>
#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @DesktopDir & "\Test.xls")

Local $aArray = _Excel_RangeRead($oWorkbook, Default, "A:A")
    _ArrayDisplay($aArray)

Edit: Sorry, I missed that you're trying to get used range only...

Modified, this works for me:

#include <Array.au3>
#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @DesktopDir & "\Test.xls")

Local $aArray = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.UsedRange.Columns("A:A"))
    _ArrayDisplay($aArray)



Edited April 8, 2015 by JLogan3o13

[water]

Parameter 1 for function_Excel_RangeRead should be the workbook object, not the Excel application object.

Means: Replace $oExcel with $oWorkbook

[JLogan3o13]

Missed that completely

[claycrosby123]

Thank you very much! Simple fix 

[water]