Get cell color Version 3 (Net)

Action group: Excel 

Description

The action gets the color from the specified cell.

Icon

Settings of parameters

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Column of the cell

The column of the cell whose color the action will return from.

String


No

Column index

The column index of the cell whose color the action will return from.

Numeric


No

Row of the cell

The cell row whose color the action will return from.

Numeric


Yes

Results

RGB color

Variable to which the color of the cell in RGB format will be written

String



Excel color

Variable to which the cell color will be written in ExcelCellInteriorColor format

String



Special conditions of use

The action should not return an error if it fails to recognize the color name. The code "RGB" should be returned in any case. 

Example of use 

Task

There is an Excel document that has a yellow cell, I need to get its color into the text variable "Color". 

Solution

Use the actions "Open", "Get cell color". 

Implementation

  1. Assemble a robot scheme consisting of actions:
  2. Customize the settings for the "Open" action:
  3. Configure the parameters for the "Get cell color" action:
  4. Launch the robot using the "Start" button in the top panel. 

Result: 

The program robot completed successfully. The color of the cell is defined and written to the variable "Color". 

  • Нет меток