how is the EXCEL ROW variable supposed to work

[forumsupport]

Hello Phil,

Line # 17 is variable operation command. Only excel command can reset $Excel Cell Row$ variable.

[philkryder]

Originally Posted by forumsupport

Hello Phil,

Line # 17 is variable operation command. Only excel command can reset $Excel Cell Row$ variable.

thanks guys!

glad you are there - this is a bit obscure - one might expect and reference to a cell to have the same results -
whether it was a variable operation or a get cell excel operation.

but,
the code below works as you indicated.
thanks!
Phil

1 Delay: (200 ms)
2 Comment: -------? how should EXCEL CELL ROW work
3 Excel : Open Spreadsheet "H:\My Documents\Automation Anywhere\Automation Anywhere\$TestDataIncludingXYgridEXCEL\EXCELrow.xl sx". Active Sheet: Default. Session: Default
4 Delay: (200 ms)
5 Excel : Set value of Cell "A1" with "a1". Session: Default
6 Delay: (200 ms)
7 Excel : Set value of Cell "A10" with "a10". Session: Default
8 Delay: (200 ms)
9 Excel : Get multiple cells from cell "A10" to cell "B10". Session: Default
10 Delay: (200 ms)
11 Start Loop " Each row in an Excel dataset of Session = Default"
12 Variable Operation : $Excel Column(1)$ To $Clipboard$
13 Comment: WHAT should be the value of CLIPBOARD and EXCEL CELL ROW in the next MESSAGE box
14 Message Box: "*$Clipboard$* *$Excel Cell Row$*"
15 Excel : Get value of cell "A1" and assign to variable "Clipboard". Session: Default
16 Comment: WHAT should be the value of CLIPBOARD and EXCEL CELL ROW in the next MESSAGE box
17 Message Box: "*$Clipboard$* *$Excel Cell Row$*"
18 Variable Operation : $Excel Column(1)$ To $Clipboard$
19 Comment: WHAT should be the value of CLIPBOARD and EXCEL CELL ROW in the next MESSAGE box
20 Message Box: "*$Clipboard$* *$Excel Cell Row$*"
21 Excel : Get value of cell "$Excel Column(1)$" and assign to variable "Clipboard". Session: Default
22 Comment: WHAT should be the value of EXCEL CELL ROW in the next MESSAGE box
23 Message Box: "*$Clipboard$* *$Excel Cell Row$*"
24 End Loop
25 Delay: (200 ms)