Set range color Version 9 (Net)

Action group: Excel 

Description

The action sets the color to the cells of the specified range.

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

Start cell column name

The column name of the start cell of the range. If the field is not filled in, the value from the "Start cell column index" field is taken.

String


No

Start cell column index

Column index of the start cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Start cell row

Row of the start cell of the range. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

End cell column name

The name of the end cell column of the range. If the field is not filled in, the value from the "End cell column index" field is taken.

String


No

End cell column index

The column index of the end cell of the range. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

End cell row

The row of the end cell of the range. If the field is not filled in, the boundary of the area to be used is taken. If the address of the end cell is less than the address of the start cell, the area that is limited to these cells will be used.

Numeric


No

Color

The color to be set in the cells of the range.

String


Yes

RGB code

RGB code to create a customizable color. It is in the format: {value for channel R}, {value for channel G}, {value for channel B}.

String


No

Special conditions of use

None.

Example of use

Task

There is an Excel document. You need to set a specific color for cells in the specified ranges. 

Solution

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

Implementation

  1. Assemble a robot scheme consisting of actions:


  2. Configure parameters for the "Open" action:


  3. Configure the parameters for the "Set range color" action. 


  4. Customize the parameter for the "Save" action. 

Result

The result of the performed actions was the setting of the selected color in the specified ranges together with the parameter "RGB - code"

The color of the specified range with the RGB parameter.