1. Component introduction
Prerequisite components: Launch Excel or Get Opened Excel
This component deletes a specified column from an Excel sheet.
2. Inputs
In the component panel of the application flow editor, you can refer to the help information for each input field.
3. Outputs
For more information about each output, see the component panel in the ROS Visual Editor.
4. Component usage example
4.1. Component configuration example
Set
Opened Sheet Objectto v_Sheet_obj_1, which is the output of the Get Active Sheet or Activate Sheet component.Set
Target Column to Deleteto "A".Use the default values for the advanced options.
4.2. Example execution result
None.
5. Example flow
Setup Flow
Use the Launch Excel component to open a specified Excel file.
Use the Get Active Sheet component to retrieve the active sheet object.
Use the Delete Excel Column component to delete a specified column from the Excel sheet.
Result
After the flow runs, it automatically opens the Excel file and deletes column A, as shown in the following figures.