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

; Create application object
Local $oExcel = _Excel_Open()
If @error Then Exit MsgBox(16, "Excel UDF: _Excel_BookOpen Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

; *****************************************************************************
; Open an existing workbook and return its object identifier.
; *****************************************************************************
Global $sWorkbook = @ScriptDir & "\defects.xlsx"
Global $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookOpen Example 1", "Error opening '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

; Read column C
Global $oRange = $oWorkbook.ActiveSheet.UsedRange.SpecialCells($xlCellTypeLastCell)
Global $aResult = _Excel_RangeRead($oWorkbook, Default, "C1:C" & $oRange.Row)
_ArrayDisplay($aResult)
; Read column E
Global $oRange = $oWorkbook.ActiveSheet.UsedRange.SpecialCells($xlCellTypeLastCell)
Global $aResult = _Excel_RangeRead($oWorkbook, Default, "E1:E" & $oRange.Row)
_ArrayDisplay($aResult)
; Read column F
Global $oRange = $oWorkbook.ActiveSheet.UsedRange.SpecialCells($xlCellTypeLastCell)
Global $aResult = _Excel_RangeRead($oWorkbook, Default, "F1:F" & $oRange.Row)
_ArrayDisplay($aResult)
; Read column H
Global $oRange = $oWorkbook.ActiveSheet.UsedRange.SpecialCells($xlCellTypeLastCell)
Global $aResult = _Excel_RangeRead($oWorkbook, Default, "H1:H" & $oRange.Row)
_ArrayDisplay($aResult)