| 1 | #include <Excel.au3>
|
|---|
| 2 | #include <Array.au3>
|
|---|
| 3 |
|
|---|
| 4 | Global $fileExcel = "Excel_AutoIt_Bug.xls"
|
|---|
| 5 | Global $arrayTest,$objExcelAttached
|
|---|
| 6 |
|
|---|
| 7 | ;~ _ExcelReadSheetToArray sets @error to 4 when called after the workbook object is attached
|
|---|
| 8 |
|
|---|
| 9 | $objExcelAttached = _ExcelBookAttach($fileExcel,"FileName")
|
|---|
| 10 | $arrayTest = _ExcelReadSheetToArray($objExcelAttached,1,1,1,8)
|
|---|
| 11 | If @error <> 0 Then
|
|---|
| 12 | ConsoleWrite("Error encountered (" & @error & ") - object was attached and active sheet wasn't changed." & @CRLF)
|
|---|
| 13 | EndIf
|
|---|
| 14 | $objExcelAttached.Sheets(2).Activate
|
|---|
| 15 | $arrayTest = _ExcelReadSheetToArray($objExcelAttached,1,1,1,8)
|
|---|
| 16 | If @error <> 0 Then
|
|---|
| 17 | ConsoleWrite("Error encountered (" & @error & ") - object was attached and active sheet was changed." & @CRLF)
|
|---|
| 18 | EndIf
|
|---|
| 19 | _ExcelBookClose($objExcelAttached)
|
|---|
