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.