Set cell color Version 10 (Net)

Action group: Excel 


Description

The action sets the color to the specified cell.

Action 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 in which the color will be set

String


No

Column index

The index of the cell column in which the color will be set

Numeric


No

Row of the cell

Cell row in which the color will be set

Numeric


Yes

RGB code

RGB color code in the format "{value for channel R}, {value for channel G}, {value for channel B}". Example: 134,108,242. Applies when the "Custom" option in the "Color" field is selected

String


No

Color

The color to be set in the selected cell

String


Yes

Special conditions of use  

If you select "No color" in the "Color" field, the fill value in the cell will become "no fill". When selecting "Custom", the "RGB code" field must be filled in, which must contain the rgb color code in the format " {value for channel R},{value for channel G},{value for channel B}". Example: 134,108,242

Example of use:

Task

There is an empty Excel document. Test.xlsx

It is necessary to change the color of the cell to the available colors, as well as to check the possibility of using RGB - code and set any color for the cell using it. 

Solution

Use the actions "Open", "Set cell color", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions: 

  2. Set the parameters for the "Open" action. 

  3. Set the parameters for the "Set cell color" action 1.

  4. Set the parameters for the "Set cell color" action 2.

  5. Set the parameters for the "Save" action. 

  6. Launch the robot using the "Start" button in the top panel.

Result

The program robot completed successfully.


The selected color has been successfully applied to the cell. 


  • Нет меток