Support with Search

[amirshaneh]

Im using this code to Array an excel table and to search it. i need help with the output of the search.

the table has 2 columns. and i am searching on column 2, i want that instead of giving me a message on where the selected Input ive searched. it will just state the cooresponding text on column 1

small example

col1-- col2

1---2

3---4

when i input 4 it will output "3" instead of writing that 4 was found on column 2 

#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <Excel.au3>

Local $sFilePath1 = @ScriptDir & "\worksheet.xlsx" ;This file should already exist
Local $oExcel = _ExcelBookOpen($sFilePath1,0)

$aArray = _ExcelReadSheetToArray($oExcel, 1, 1, 0, 2) ;Read 2 Columns

_ExcelBookClose($oExcel, 0)

Local $sSearch = InputBox("_ArraySearch() demo", "String to find?")
If @error Then Exit

Local $sColumn = 2
If @error Then Exit
$sColumn = Int($sColumn)

Local $iIndex = _ArraySearch($aArray, $sSearch, 0, 0, 0, 1, 1, $sColumn)
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Not Found", '"' & $sSearch & '" לא נמצאה הכתובת המבוקשת ' & '.')
Else
    MsgBox($MB_SYSTEMMODAL, "Found", '"' & $sSearch & '" was found in the array at position ' & $iIndex & ' on column ' & $sColumn & '.')
EndIf

Thanks in advance.

Amir

[BrewManNH]

Once you've gotten the index number, you can then use $aArray[$iIndex][0] to tell you what was in column one at that index.

[amirshaneh]

still didnt get it to work. im really a noobie with autoit. maybe you can help me with a proper code that i should use?

[kylomas]

amirshaneh,

Try changing $sColumn to 1.  Columns, as well as rows are zero based.

kylomas

[amirshaneh]

amirshaneh,

Try changing $sColumn to 1.  Columns, as well as rows are zero based.

kylomas

 

If i change $sColumn to 1 then it will not find what i am looking for since $sColumn is used to search the 2nd column for the thing you want