1. Component introduction
Prerequisite components: Start Excel or Get Opened Excel
This component purges the content and format of a specified cell area in Excel.
2. Inputs
For more information about each input, see the help information in the component panel of the application flow editor.
3. Outputs
For more information about each output, see the help information in the component panel of the application flow editor.
4. Component usage example
4.1. Component configuration example
For
Opened sheet object, select v_Sheet_obj_1. This is the output of a prerequisite component such as Get Active Sheet or Activate Sheet.For
Start row of area, enter "1".For
Start column of area, enter "A".For
End row of area, enter "2".For
End column of area, enter "B".For
Purge format, select "Yes".Default Values for Advanced Options
4.2. Example result
None
5. Example of building a flow
Setup flow
Use the Start Excel component to start a specified Excel file.
Use the Get Active Sheet component to obtain the active sheet object.
Use the Purge Excel Area component to purge the content and format of a specified cell area.
Execution result
After the flow runs successfully, it automatically opens the Excel file and purges the content and format of the cells in the specified area A1:B2, as shown in the following figures.
