bin123485 Posted August 9, 2014 Posted August 9, 2014 #include <Array.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> Local $oAppl = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir & "\1.xls") Local $aResult = _Excel_RangeRead($oWorkbook, 1, "A1:C1", 2) _ArrayDisplay($aResult, "Excel UDF: _Excel_RangeRead Example 2 - Cells A1:C1 of sheet 2") Local $iData = $aResult[0] Error Massage: "E:AU3testtest.au3" (12) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.: Local $iData = $aResult[0] Local $iData = ^ ERROR why is that? $sResult is not an array?
water Posted August 9, 2014 Posted August 9, 2014 If there is no error returned by _Excel_RangeRead then it is an array. In fact a 2D array because you read multiple rows and columns. So you need two index variables to access the content of the array. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
bin123485 Posted August 9, 2014 Author Posted August 9, 2014 (edited) If there is no error returned by _Excel_RangeRead then it is an array. In fact a 2D array because you read multiple rows and columns. So you need two index variables to access the content of the array. yes. it's a 2D array. Thanks. Another question: I want to get the number of rows in the array $aResult. Ubound($aResult) is 65536. So how can I get the correct number? Edited August 9, 2014 by bin123485
water Posted August 9, 2014 Posted August 9, 2014 (edited) Please check example 3 in the help file for function _Excel_RangeRead. It reads all used cells of a column by using $oWorkbook.ActiveSheet.Usedrange.Columns("A:A") Edited August 9, 2014 by water My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
bin123485 Posted August 10, 2014 Author Posted August 10, 2014 Please check example 3 in the help file for function _Excel_RangeRead. It reads all used cells of a column by using $oWorkbook.ActiveSheet.Usedrange.Columns("A:A") It works. Thank you very much.
water Posted August 10, 2014 Posted August 10, 2014 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now