Opened 9 years ago
Closed 9 years ago
#2569 closed Bug (Wont Fix)
_ExcelReadSheetToArray - Error Code 4 When Excel Object Was Attached
| Reported by: | squishy | Owned by: | |
|---|---|---|---|
| Milestone: | Component: | Standard UDFs | |
| Version: | 3.3.10.0 | Severity: | None |
| Keywords: | Cc: |
Description
The function _ExcelReadSheetToArray seems to always throw error 4 whenever called on an Excel object that was attached and not opened. I have traced the error back to line 533 in the function Excel.au3, where an ambiguous reference seems to be the issue. If you add the 'ActiveSheet' scope to the range when declaring the array, it seems to fix the issue:
Current line 533:
Local $aArray = $oExcel.ActiveSheet.Range($oExcel.Cells($iStartRow, $iStartColumn), $oExcel.Cells($iLastRow, $iLastColumn)).Value
Fixed line 533:
Local $aArray = $oExcel.ActiveSheet.Range($oExcel.ActiveSheet.Cells($iStartRow, $iStartColumn), $oExcel.ActiveSheet.Cells($iLastRow, $iLastColumn)).Value
I have included both a code file and a test Excel file for you to test out.
Attachments (2)
Change History (7)
Changed 9 years ago by anonymous
Changed 9 years ago by squishy
comment:1 Changed 9 years ago by BrewManNH
Version 3.3.8.1 is no longer the current version, have you tried this on the new release version? Does it still demonstrate the problem? The newest version is 3.3.10.0.
comment:2 Changed 9 years ago by guinness
Yes it does. Changed the version.
comment:3 Changed 9 years ago by guinness
- Version changed from 3.3.8.1 to 3.3.10.0
comment:4 Changed 9 years ago by guinness
Your proposed fix does not actually fix the error.
comment:5 Changed 9 years ago by water
- Resolution set to Wont Fix
- Status changed from new to closed
Won't be fixed because the next Beta of Autoit will include a completely rewritten Excel UDF.
Guidelines for posting comments:
- You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
- In-depth discussions should take place on the forum.
For more information see the full version of the ticket guidelines here.
Dummy Excel File