Action group:  Excel Set range color


Action icon

Version:

  • 8 (net)

Action sets the color to the cells of the specified range

Settings

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 nameThe 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 indexColumn 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 rowRow 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 nameThe 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 indexThe 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


 


Version:

  • 7 (net)

Action sets the color to the cells of the specified range

Settings

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 nameColumn of the start cell of the range. If the field is not filled in, the boundary of the used area is taken.String
No
Start cell rowRow 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 nameColumn 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.String
No
End cell rowRow 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
ColorThe color to be set in the cells of the range.String
Yes
RGB codeRGB code for creating a customizable color. It is in the format: {value for channel R}, {value for channel G}, {value for channel B}String
No


 


Version:

  • 6 (net)
  • 5 (net)
  • 4 (net)
  • 3 (net)
  • 2 (net)
  • 1 (net)

Action sets the color to the cells of the specified range

Settings

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 cellAddress of the start cell of the range. Fill in the format "XY", where "X" is the column number and "Y" is the row number. If the field is not filled in, the boundary of the used area is taken.String
No
End cellAddress of the end cell of the range. Fill in the format "XY", where "X" is the column number and "Y" is the row number. If the field is not filled in, the boundary of the used area is taken. If the address of the end cell is less than the address of the start cell, then the area bounded by these cells will be used.String
No
ColorThe color to be set in the cells of the range.String
Yes
RGB codeRGB code for creating a customizable color. It is in the format: {value for channel R}, {value for channel G}, {value for channel B}String
No
  • Нет меток