A group of actions: Excel
The action sets the format of cells from the specified range
Action icon
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Start cell column name | The 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 index | The 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 row | Row 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 name | The 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 index | The 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 row | Row 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. 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 | |
| Format | The format to be set in the selected range of cells | Robin.String | Yes | |
| Format mask | Mask for creating a custom format. Rules for custom format masks: 1) Any custom text (kg, people, pcs and the like) or symbols (including spaces) must be enclosed in quotes. 2) You can specify several (up to 4) different format masks separated by semicolons. Then the first of the masks will be applied to the cell if the number in it is positive, the second - if it is negative, the third - if the cell content is zero, and the fourth - if the cell contains not a number, but text. 3) ** 0 (zero) ** - one obligatory familiarity (digit), i.e. this place in the format mask will be filled with a digit from the number that the user enters into the cell. If there is no number for this familiarity, then zero will be displayed. For example, if you apply the mask 0000 to the number 12, you get 0012, and if you apply the mask 0.00 to the number 1.3456, you get 1.35. 4) ** # (hash) ** - one optional familiarity - roughly the same as zero, but if there is no number for the familiarity, then nothing is displayed 5) ** (space) ** - used as a separator of groups of digits three between thousands, millions, billions, etc. 6) ** [] ** - in square brackets before the format mask, you can specify the font color. The following colors are allowed: black, white, red, blue, green, yellow, cyan. | Robin.String | No | |
Обзор
Инструменты контента