Man illustrationFlower illustration
Excel

Set cell style

Estimated reading: 3 minutes 305 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 reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet nameThe name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet indexIndex of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeThe range of cells to be changed data is given.
Fill colorThe background color of the cell is written as RGB values or the name of the color.
Font colorThe text color is written as RGB values or the name of the color.
BoldThis checkbox provides changing the font thickness.
ItalicThis checkbox provides italicization.
UnderlineThis checkbox provides underlining.
Font sizeThe font size is adjusted. The desired font number is written in this area.
Font nameThe font type is written.
Wrap text?Wrap text is the automatic adjustment of text to fit within a confined space, such as a cell or text box, by breaking the text into multiple lines
Has border?Whether borders (Frame) will be present or not is selected.
Border styleThe border style that will be applied is selected.
Border position?The position of the border that will be applied is selected.
Border colorThe border color of the cells is is written as RGB values or the name of the color.
Vertical alignmentVertical alignment of the cells.
Horizontal alignmentHorizontal alignment of the cells.
Is hyperlink?This checkbox provides converting text to hyperlink.
UrlThis textbox provides url 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 Sheet index as shown in the example.

5

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

Share this Doc

Set cell style

Or copy link

CONTENTS
Chat Icon Close Icon