Skip to main content

ChangeRangeStyles

Applies font, alignment, and text style formatting to a specified range of cells in an Excel worksheet.

Core Functions

  • Updates font and text style properties for a cell range
  • Controls horizontal and vertical alignment

Inputs

  • FilePath: Specifies the file path of the Excel file to be updated
    Type: String

  • Range: Specifies the cell range to which styles will be applied
    Type: String

  • FontName: Specifies the font name to apply to the cell range
    Type: String

  • FontSize: Specifies the font size to apply to the cell range
    Type: Integer

  • HexColor: Specifies the font color in hexadecimal format
    Type: String

  • HAlign: Specifies the horizontal alignment of the cell content
    Type: String

  • VAlign: Specifies the vertical alignment of the cell content
    Type: String

  • IsBold: Determines whether the text is bold
    Type: Boolean

  • IsItalic: Determines whether the text is italic
    Type: Boolean

  • IsStrikethrough: Determines whether the text has a strikethrough effect
    Type: Boolean

  • UnderlineStyle: Specifies the underline style applied to the text
    Type: String

Outputs

  • Output: This activity does not return a direct output value
    Type: None

Short Technical Summary

Applies comprehensive styling options, including font, color, alignment, and text effects, to a specified Excel cell range.