Use the Get cell color action in the Excel advanced
package of Automation 360 to retrieve the background or text
color of a cell as RGB (Red, Green, Blue) values. For example, red is 255,0,0.
Before you begin
Ensure that an Excel session is active and a spreadsheet is open.
Procedure
-
Double-click or drag the Get cell color action from the
Excel node in the Actions
palette.
-
Select the Background color option to get the background
color of the cell or the Text color to get the color of the
text.
-
Select the Active cell option to retrieve the color from the
current active cell, or select Specific cell to specify a cell
by address.
-
If you selected Specific cell, enter the cell address (for
example, A1) in the cell address field.
-
Select a variable from the Assign the output to variable
list to store the retrieved RGB color value.
The
shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
-
Enter
the name of the session used to open the workbook
with the Open
.
-
Select Save.