Man illustrationFlower illustration

Docy

Set cell style

Estimated reading: 3 minutes 62 views

Set cell style activity is used for formatting the cell styles of the desired ranges in the worksheet of an Excel file.


*Excel nameThe name of the Excel file that was opened or created before is selected.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeExcel sheet range from which to fetch data.
Fill colorBackground color of the cell. Two supported input types: name of the color or rgb values.
Font colorText color. Two supported input types: name of the color or rgb values.
BoldIt allows you to change the font thickness.
ItalicIt allows italicization.
UnderlineIt allows underlining the text inside the cell.
Font sizeThe font size is adjusted.
Font nameThe font type is specified.
Has border?Select whether borders (Frame) will be present or not.
Border styleBorder style that will be applied.
Border position?Position of border that will be applied.
Border colorBorder color of the cells.
Vertical alignmentVertical alignment of the cells.
Horizontal alignmentHorizontal alignment of the cells.
Is hyperlink?Converts text to hyperlink.
UrlUrl value to be converted to hyperlink.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1

A1:B5

You can use the Font color file name as shown in the example.

255,0,0 (Red)

255,255,0 (Yellow)

You can use the Font size as shown in the example.

9

You can use the Font name as shown in the example.

Arial

You can use the Border style as shown in the examples.

NONE

THIN

MEDIUM

DASHED

DOTTED

THICK

DOUBLE

You can use the Border position as shown in the examples.

ALL

NONE

TOP

BOTTOM

LEFT

RIGHT

You can use the Border color as shown in the examples.

yellow

255,56,180

You can use the Vertical alignment as shown in the examples.

NONE

TOP

CENTER

BOTTOM

JUSTIFY

DISTRIBUTED

You can use the Horizontal alignment as shown in the examples.

NONE

GENERAL

LEFT

CENTER

RIGHT

FILL

JUSTIFY

CENTER_SELECTION

DISTRIBUTED

CONTENTS