Arg. Never fails. When I ask I figure it out.
Here is what I finally did. If anyone has any improvements or suggestions please send them my way.
First here is the structure of my data after import with _XLSXReadtToArray
$ClientList[0][0]:=2
$ClientList[0][1]:=
$ClientList[0][2]:=
$ClientList[1][0]:=Name1
$ClientList[1][1]:=Tag
$ClientList[1][2]:=Date Effective
$ClientList[2][0]:=Name2
$ClientList[2][1]:=Tag2
$ClientList[2][2]:=
Obviously this is just a sample file for test purposes. What I was looking to do was have 2,1 3,1 4,1 5,1 etc display in a combo box, and then have the corresponding 2,2 3,2 4,2 5,2 etc sent on to my print script.
First I used the following two functions to create the array and then to create a var with the data to load into the combo box.
Func _LoadClients ()
$t = TimerInit()
$ClientList = _XLSXReadToArray("L:\Databases\clients.xlsx")
$Error = @Error
$Extended = @Extended
$t = TimerDiff($t)
;~ ConsoleWrite("Timer = " & $t & @LF)
;~ ConsoleWrite("Return = " & $ClientList & " - $Error = " & $Error & " - $Extended = " & $Extended & @LF)
EndFunc
Func _DisplayClientName ()
$s = $ClientList[0][0]
For $i = 1 To $s Step 1
$list123 &= "|" & $ClientList[$i][0]
Next
EndFunc
Next I loaded both functions sequentially when the GUI with the print interface is loaded (Actually when the button is pushed to open that GUI)
I also had the same button load the $list123 into the combo box with GUICtrlSetData($privateComboList, $list123)
Finally when my user clicks the "print" button on my GUI it calls the following script
Func _SearchClientTag ()
$ClientName = GUICtrlRead($privateComboList)
ConsoleWrite ("Begin Search"&@LF)
ConsoleWrite ($ClientName & @LF)
$result = _ArraySearch($ClientList, $ClientName)
ConsoleWrite ("error code is: " & @error & @LF)
ConsoleWrite ("Client Name is : " & $result & @LF)
$aftertag = $ClientList[$result][1]
ConsoleWrite ("The Tag line is: " & $aftertag & @LF)
EndFunc
$aftertag is a global variable I have set that is later used to replace a identifier in an xml file that triggers the actual printing.
Also I should note that I have declarded $ClientList and $list123 as globals elsewhere.
Hope this helps someone.