1. Component description
Prerequisite components: Launch Excel or Get opened Excel
This component sets the font color for a specified area.
2. Inputs
For information about each input, see the component panel in the application flow editor.
3. Outputs
For information about each output, see the component panel in the application flow editor.
4. Component usage example
4.1. Component configuration example
Set
Opened sheet objectto v_Sheet_obj_1, which is the output of a prerequisite component such as Get active sheet or Activate sheet.For
Start row number of area, use the default value "1".For
Start column letter of area, use the default value "A".For
End row number of area, use the default value "2".For
End column letter of area, use the default value "C".For Font color in area, select red.
Keep the default values for the advanced options.
4.2. Example result
None
5. Example of building a flow
Setup flow
Use the Launch Excel component to launch a specified Excel file.
Use the Get active sheet component to obtain the active sheet object.
Use the Set Excel area font color component to set the font color for a specified area.
Result
After the flow runs, the font color in the specified area of the table changes from black to red.