Accessing Data in an array from Excel

[Eminence]

Hello,

Is there a way wherein I can access the data from an array coming from an Excel file then have it assigned on to a variable?

Below is a snippet of my current code. For now, it just reads and outputs the data from the excel file and have it displayed via an array.

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

Local $oExcel = _Excel_Open(False)
    If @error Then Exit MsgBox(0, "Error", "Error creating application object." & @CRLF & "Error: " & @error & " Extends: " & @extended)

; Open Excel Woorkbook and return object
Local $sWorkbook = @ScriptDir & "\Excel Files\Test Data.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, False, True)
    If @error Then
        MsgBox(0, "Error", "Error opening workbook'" & $sWorkbook & ".'" & @CRLF & "Error: " & @error & "Extends: " & @extended)
        _Excel_Close($oExcel)
        Exit
    EndIf

Local $aResult = _Excel_RangeRead($oWorkbook)
    ; Error Trapping
    If @error Then
        MsgBox(0, "Error", "Error reading data from '" & $sWorkbook & ".'" & @CRLF & "Error: " & @error & " Extends: " & @extended)
        _Excel_Close($oExcel)
        Exit
    EndIf
_ArrayDisplay($aResult)

My Excel file has values from Column A to H with values from 1 to 30, what I desired to do is have the value in "A7" assigned on to a variable. 

 

Any help is appreciated. Thanks in advance.

[water]

Quite easy

$sResult = _Excel_RangeRead($oWorkbook, Default, "A7")

 

[JLogan3o13]

@Eminence welcome to the forum, but please pay attention to where you post in the future. The DEV forum very clearly states:

 

Quote

Do not create AutoIt-related topics here, use AutoIt General Help and Support

 

[Eminence]

20 hours ago, water said:

Quite easy

$sResult = _Excel_RangeRead($oWorkbook, Default, "A7")

 

Oh lol. Thanks!

19 hours ago, JLogan3o13 said:

@Eminence welcome to the forum, but please pay attention to where you post in the future. The DEV forum very clearly states:

 

 

My bad. Will do next time. Thank you!