A group of actions: Excel


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

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Start cell column nameThe column name of the starting cell of the range. If the field is not filled, then the value from the «Start cell column index» field is taken.Robin.String No
Start cell column indexThe column index of the starting cell (start of the range) from which the region will be set. If the field is not filled, then the border of the used area is taken.Robin.Numeric No
Start cell rowRow of the starting cell of the range. If the field is not filled, then the border of the used area is taken.Robin.Numeric No
End cell column nameThe column name of the ending cell of the range. If the field is not filled, then the value from the «End cell column index» field is taken.Robin.String No
End cell column indexThe column index of the ending cell of the range. If the field is not filled, then the border of the used area is taken.Robin.Numeric No
End cell rowRow of the ending cell of the range. If the field is not filled, then the border 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 that is limited by these cells will be used.Robin.Numeric No
ColorThe color to be set in the cells of the range.Robin.String Yes
RGB codeRGB code to create a custom color. It is entered in the format: {value for the R channel}, {value for the G channel}, {value for the B channel}Robin.String No
  • Нет меток