1. Component introduction
Prerequisites: The Start Excel or Get opened Excel component, and the Get active sheet component.
You can use this component to loop through and process each row in a specified area of an Excel sheet.
2. Input items
For more information, see the help text for each input item in the component panel of the application flow editor.
3. Output items
For more information, see the help text for each output item 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 object from the Get active sheet or Activate sheet component.For Image path, enter the path of the image to insert, such as "C:\Users\username\Desktop\1.png".
For Left margin, enter the distance of the image from the left edge. The default value is 0.
For Top margin, enter the distance of the image from the top edge. The default value is 0.
Set Width to 50.
Set the height of the image to 50.
Keep the default values for the advanced options.
4.2. Example execution result
None
5. Example flow
Build the flow
Use the Start Excel component to open a specified Excel sheet.
Use the Get active sheet component to obtain the active sheet object.
Use the Insert an image into Excel component to insert the specified image into the sheet.
Execution result
After the flow runs successfully, the image is inserted into the sheet as shown in the following figure.