Set font style for an Excel range
1. Introduction
Prerequisites: Start Excel or Get opened Excel
This component sets the font style for a specified range.
2. Inputs
For more information about the input parameters, see the component's help text in the application flow editor.
3. Outputs
For more information about the output parameters, see the component's help text in the application flow editor.
4. Component usage examples
4.1. Configuration example
For
Opened Sheet Object, select `v_Sheet_obj_1`, which is the output of a prerequisite component such as Get current active sheet or Activate sheet.For
Start Row, keep the default value "1".For
Start Column, keep the default value "A".For
End Row, keep the default value "2".For
End Column, keep the default value "C".For
Font Style, select "Bold" from the drop-down list.Keep the default values for the advanced options.
4.2. Example execution results
None
5. Example flow
Setup flow
Use the Start Excel component to open a specific Excel file.
Use the Get current active sheet component to obtain the active sheet object.
Use the Set font style for an Excel range component to set the font style of the specified range to "Bold".
Result
After the flow runs, the font style in the specified range changes from regular to bold, as shown in the following figures.
