Set cell style
Set cell style activity is used for formatting the cell styles of the desired ranges in the worksheet of an Excel file.
| *Excel name | The reference name of the excel file which has already been opened or created is chosen in the dropdown. |
| Sheet name | The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. |
| Range | The range of cells to be changed data is given. |
| Fill color | The background color of the cell is written as RGB values or the name of the color. |
| Font color | The text color is written as RGB values or the name of the color. |
| Bold | This checkbox provides changing the font thickness. |
| Italic | This checkbox provides italicization. |
| Underline | This checkbox provides underlining. |
| Font size | The font size is adjusted. The desired font number is written in this area. |
| Font name | The font type is written. |
| Has border? | Whether borders (Frame) will be present or not is selected. |
| Border style | The border style that will be applied is selected. |
| Border position? | The position of the border that will be applied is selected. |
| Border color | The border color of the cells is is written as RGB values or the name of the color. |
| Vertical alignment | Vertical alignment of the cells. |
| Horizontal alignment | Horizontal alignment of the cells. |
| Is hyperlink? | This checkbox provides converting text to hyperlink. |
| Url | This checkbox provides url value to be converted to hyperlink. |
Note: * Fields selected with are required, others are optional.
Excel name example
You can use the Excel name as shown in the example.
${newExcel}
Sheet name example
You can use the Sheet name file name as shown in the example.
Sheet1
Range examples
You can use the Range as shown in the example .
A1
A1:B5
Font color examples
You can use the Font color file name as shown in the example .
255,0,0 (Red)
255,255,0 (Yellow)
Font size example
You can use the Font size as shown in the example .
9
Font name example
You can use the Font name as shown in the example .
Arial
Border style examples
You can use the Border style as shown in the examples.
NONE
THIN
MEDIUM
DASHED
DOTTED
THICK
DOUBLE
Border position examples
You can use the Border position as shown in the examples.
ALL
NONE
TOP
BOTTOM
LEFT
RIGHT
Border color examples
You can use the Border color as shown in the examples.
yellow
255,56,180
Vertical alignment examples
You can use the Vertical alignment as shown in the examples.
NONE
TOP
CENTER
BOTTOM
JUSTIFY
DISTRIBUTED
Horizontal alignment examples
You can use the Horizontal alignment as shown in the examples.
NONE
GENERAL
LEFT
CENTER
RIGHT
FILL
JUSTIFY
CENTER_SELECTION
DISTRIBUTED