erreur local $b=_ArraytoString($f[2]) local $b=_ArraytoString(^ ERROR

[oulaya]

help

For $i = 19 To 26 ;Loop

$test = $oExcel.Activesheet.Cells($i,12).value

local $f=StringSplit($test," ")

Local $pa = _IEGetObjByName($oIE,"containerNoeud:agglo")
_IEFormElementSetValue ($pa,$f[1])

sleep(1000)
local $b=_ArraytoString($f[2])
local $a=StringSplit($b,'/')

Local $pa = _IEGetObjByName($oIE,"containerNoeud:site")

_IEFormElementSetValue ($pa,$a[1])
Local $pa = _IEGetObjByName($oIE,"containerNoeud:point")
_IEFormElementSetValue ($pa,$a[2])
 ;MsgBox($f[2], "","ll")
Next
sleep(2000)

(81) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:
local $b=_ArraytoString($f[2])
local $b=_ArraytoString(^ ERROR

[water]

Shouldn't it be:

local $b = _ArraytoString($f)

because the function expects an array not an element of an array.

[oulaya]

so what can i do

[oulaya]

i try it but i have this problem now

_IEFormElementSetValue ($pa,$a[2])
_IEFormElementSetValue ($pa,^ ERROR

[water]

You need to check that _StringSplit found a separater character. If not then there will be no element [2] in the array.
Check @error: "If no delimiters were found then the @error flag is set to 1:"
As always the help file is your friend

[oulaya]

my data like

oulaya oulaya/oulaya

 

[oulaya]

for the first oulaya  its ok but 2 and 3 no

[water]

Try this:

#include <Array.au3>
$sString = "oulaya1 oulaya2/oulaya3"
$aString = StringSplit($sString, " /") ; Note the space in the second parameter
_ArrayDisplay($aString)

With one statement you can split the string into 3 parts.

[oulaya]

i want to take value1 in case 1 and value 2 in case 2 and value 3 in case 3 ???

[water]

Sorry, I do not get what you want

[oulaya]

i have data like  oulaya1 oulaya2/oulaya3 i want take data oulaya1    oulaya2          oulaya3 and put in my textline

[water]

Local $oIEObject, $sCellValue, $aCellValues
For $i = 19 To 26 ;Loop
    $sCellValue = $oExcel.Activesheet.Cells($i, 12).value
    $aCellValues = StringSplit($sCellValue, " /")
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:agglo")
    _IEFormElementSetValue($oIEObject, $aCellValues[1])
    Sleep(1000)
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:site")
    _IEFormElementSetValue($oIEObject, $aCellValues[2])
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:point")
    _IEFormElementSetValue($oIEObject, $aCellValues[3])
Next
Sleep(2000)

 

[oulaya]

Thanks

but i still have this problem

 ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:
_IEFormElementSetValue($oIEObject, $aCellValues[2])
_IEFormElementSetValue($oIEObject, ^ ERROR

and it put the value in right place

[water]

In this case the input data is incorrect. It can't be split into 3 parts. Write

$sCellValue

to the Console and check if it has the expected value.

[oulaya]

i didn't understand

 

[oulaya]

the data is like oulaya1 oulaya2/oulaya3

 

[water]

Add some error checking to your script.

[oulaya]

i didn't now how to add erroe cheking in my script

[water]

Seems you need to take a deep look into the help file and the AutoIt tutorials soon

[water]

#include <Array.au3>
Local $oIEObject, $sCellValue, $aCellValues
For $i = 19 To 26 ;Loop
    $sCellValue = $oExcel.Activesheet.Cells($i, 12).value
    $aCellValues = StringSplit($sCellValue, " /")
    _ArrayDisplay($aCellvalues) ; <== What do you get?
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:agglo")
    _IEFormElementSetValue($oIEObject, $aCellValues[1])
    Sleep(1000)
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:site")
    _IEFormElementSetValue($oIEObject, $aCellValues[2])
    $oIEObject = _IEGetObjByName($oIE, "containerNoeud:point")
    _IEFormElementSetValue($oIEObject, $aCellValues[3])
Next
Sleep(2000)

What does _arrayDisplay show?