1. Component introduction
Prerequisites: Start Excel or Get opened Excel
Use this component to delete entire rows from an Excel file.
2. Inputs
For details about each input, refer to the help text in the component panel of the application flow editor.
3. Outputs
For details about each output, refer to the help text in the component panel of the application flow editor.
4. Component usage example
4.1. Component configuration example
For the
Opened sheet objectparameter, select v_Sheet_obj_1. This value is the output of a preceding component, such as Get active sheet or Activate sheet.For the
Row number to deleteparameter, enter "1".Default values for advanced options
4.2. Example result
None
5. Flow creation example
Setup flow
Use the Start Excel component to open the specified Excel file.
Use the Get active sheet component to retrieve the active sheet object.
Use the Delete Excel rows component to delete the specified row from the Excel sheet.
Execution result
When the flow runs successfully, it opens the Excel file and deletes the first row, as shown in the following figures.