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.