Quote:
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)