Page 1 of 1

get Excel cell text into script depend on script output

Posted: 31 Mar 2014, 18:33
by adhamdwikat
i have a situation and cannot find solution for it

if i have script node with output named "rowIndex"
and have excel cell node

how can I make a connection between the tow nodes to get the cell Text into the script node depend on the output named rowIndex ?

i tried to bind connections between them but i faced the problem of 'infinite binding loop'

for example asume that i have excel file with three rows with texts {"row 1","row 2","row 3"} respectively, and i have script node that have an output named rowIndex that is bound to Row Index input in excel cell node , and i have input named textFromExcel in script node .
what i was expect is :when i change rowIndex value to 2 i will get the text "row 2" in the input textFromExcel,
but what i got was : ''infinite binding loop'

Re: get Excel cell text into script depend on script output

Posted: 01 Apr 2014, 08:13
by Daniel Willer
Hi there

because of the validation mecanism it is not allowed to create a "binding loop" cause this would cause an endless recursion. Therefore there is a node called LoopBreaker that can be used in these cases.

Regards
Daniel

Re: get Excel cell text into script depend on script output

Posted: 01 Apr 2014, 18:41
by adhamdwikat
excellent , thats it , thanks :)