Apply Style

Set the style of excel range.

Set the style within the specified excel range.Set font style and cell style of the specified excel range.

This activity can only be used after the Open Excel File activity.

Input

• Input : ExcelHandle Variable A variable name that references the opened excel filehandle.

• Sheet Name : String Argument The name of the sheet in which the range color is to be set.

• Range : String Argument The cell range in which the color is to be set.

The range is specified in A1:E10 or A1 format. A1:E10 will select all cells of the first five columns from row 1 to 10. A1 will select first cell from first row.

Font Style

• Font Name : The font name to be set to the range of data. system font names are shown in the dropdown.

• Font Size : Integer Argument

  The font size to be set to the range of data.

• Font Weight : The font Weight to be set to the range of data.

  • Bold - set the specified range of data as bold.

  • Normal - set the specified range of data as normal font weight.

• Font Style : The font style to be set to the range of data.

  • Italic - set the specified range of data as italic.

  • Underline - underline the specified range of data.

  • None - font style is not set.

• Font Color : The font color to be set to the range of data. The default value is Not Set.

• Cell Background Color : The background cell color to be set to the range of data. The default value is Not Set.

Cell Style

• Cell Border : The cell border to be set to the range of data.

  • BottomBorder - set the border at the bottom of the range.

  • TopBorder - set the border at the top of the range.

  • LeftBorder - set the border at the left of the range.

  • RightBorder - set the border at the right of the range.

  • NoBorder - the border will not be set.

  • OutsideBorder - set the border at the outside of the range.

  • AllBorders - set all borders of the range.

• Border Thickness : The border thickness to be set to the range of data.

  • Hairline - set the border a hairline.

  • Thin - Set the border a thin line.

  • Medium - set the border as medium thickness.

  • Thick - set the border as a thick line.

• Border Color : The border color to be set to the range of data. The default value is Not Set.