1. Component description
Prerequisites: Start Excel or Get Opened Excel
This component sets the font size for a specified area in an Excel sheet.
2. Inputs
For details about each input, see the help information in the component pane of the application flow editor.
3. Outputs
For details about each output, see the help information in the component pane of the application flow editor.
4. Component example
4.1. Example configuration
For
Opened sheet object, select 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, keep the default value "1".For
Start column letter of area, keep the default value "A".For
End row number of area, keep the default value "2".For
End column letter of area, keep the default value "C".For
Font size in area, set the value to "20".Keep the default values for the advanced options.
4.2. Example result
None
5. Example flow
Setup flow
Use the Start Excel component to start a specified Excel file.
Use the Get Active Sheet component to retrieve the active sheet object.
Use the Set Font Size for Excel Area component to set the font size for the specified area.
Result
After the flow is run, the font size in the specified area of the sheet changes from 11 to 20. The following figures show the result.