Jump to content
Sign in to follow this  
joeloyzaga

read an array using a variable as the index number

Recommended Posts

I want to read down an array using a variable as the index but I keep getting

Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

is there a simple way? using Ubound,Lbound?

Joe

Share this post


Link to post
Share on other sites

We need to see your code.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

global $arraymax= 10, $arraydatamax= 3;[0..9][0..2]
main()
func main()
    local $array[$arraymax][$arraydatamax]
    ;use index variables to set array's data
    for $i= 0 to $arraymax-1
        for $ii= 0 to $arraydatamax-1
            $array[$i][$ii]= $ii
        next;ii
    next;i
    arrayout($array);display array, variable indexes and array data
EndFunc;main()

func arrayout($array);use index variables to display array's data in SciTE
    for $i= 0 to $arraymax-1
        for $ii= 0 to $arraydatamax-1
            consolewrite("$array["&$i&"]["&$ii&"]= "&$array[$i][$ii]&@crlf)
        next;ii
    next;i
EndFunc;arrayout()

Edited by Xandy

Share this post


Link to post
Share on other sites

For $iRow = 2 To $rows-1

;$arrdisp = $aArray[5]

MsgBox (0,"rows",_ArrayToString($aArray[$iRow]))

$TestOne.AddStepResult($DataXSL.GetParameter("Description",$iRow),$DataXSL.Path,1)

;SplashTextOn("XLS Data Provider - Row: " & $iRow,"Description: " & $DataXSL.GetParameter("Description",$iRow) & @CRLF & "Entry: " & @CRLF & $DataXSL.GetParameter("Entry",$iRow))

SplashTextOn("XLS Data Provider - Row: " & $iRow,"Description: " & $aArray[1][0]& @CRLF & "Entry: " & @CRLF & $DataXSL.GetParameter("Entry",$iRow))

Next

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...