Skip to content

Set Cell Style Activity

The Set Cell Style activity enables users to apply various formatting options to specific cell ranges within an Excel worksheet. This activity allows for comprehensive customization of cell appearance, including colors, fonts, borders, and alignment.

Field Description Requirement
Excel name The reference name of the Excel file, which must already be open or created, is selected from a dropdown. Required
Sheet name The name of the Excel sheet to work within. If not specified, the activity defaults to the first sheet. Optional
Sheet index The index of the Excel sheet to work within. If not specified, the activity defaults to the first sheet. Optional
Range The specific range of cells whose styles will be modified. Optional
Fill color The background color of the cell, specified as RGB values (e.g., 255,0,0) or a color name (e.g., Red). Optional
Font color The text color, specified as RGB values (e.g., 255,0,0) or a color name (e.g., Red). Optional
Bold A boolean option to apply bold formatting to the font. Optional
Italic A boolean option to apply italic formatting to the font. Optional
Underline A boolean option to apply underlining to the font. Optional
Font size The desired font size, specified as a numerical value. Optional
Font name The desired font type, specified by its name (e.g., Arial). Optional
Wrap text? A boolean option to automatically adjust text to fit within a cell by breaking it into multiple lines. Optional
Has border? A boolean option to determine if borders should be applied to the cells. Optional
Border style The style of the border to be applied (e.g., THIN, DASHED). Optional
Border position? The position of the border to be applied (e.g., ALL, TOP). Optional
Border color The color of the border, specified as RGB values (e.g., 255,56,180) or a color name (e.g., yellow). Optional
Vertical alignment The vertical alignment of content within the cells (e.g., TOP, CENTER). Optional
Horizontal alignment The horizontal alignment of content within the cells (e.g., LEFT, CENTER). Optional
Is hyperlink? A boolean option to convert the cell's text into a hyperlink. Optional
Url The URL value to be used when converting cell text to a hyperlink. This field is only relevant if Is hyperlink? is enabled. Optional

Action Types & Examples

Activity Execution

  • Format: boolean
  • Example Result: true

Implementation Examples

Field Setup - Excel name - Sheet name - Sheet index - Range - Fill color - Font color - Bold - Italic - Underline - Font size - Font name - Wrap text? - Has border? - Border style - Border position? - Border color - Vertical alignment - Horizontal alignment - Is hyperlink? - Url

Execution Parameters - Excel name: ${newExcel} - Sheet name: Sheet1 - Sheet index: 5 - Range: A1:B5 - Fill color: 255,0,0 - Font color: 255,255,0 - Bold: true - Font size: 9 - Font name: Arial - Wrap text?: true - Has border?: true - Border style: THIN - Border position?: ALL - Border color: yellow - Vertical alignment: CENTER - Horizontal alignment: LEFT - Is hyperlink?: true - Url: "https://www.example.com"

Technical Notes

  • When Sheet name or Sheet index are not explicitly provided, the activity defaults to operating on the first sheet of the specified Excel file.
  • Colors (e.g., Fill color, Font color, Border color) can be specified using either standard color names (e.g., Red, yellow) or RGB triplet values (e.g., 255,0,0 for red, 255,56,180 for a specific pink).