Insert picture

1、 Video example

To be launched.

 

2、 Function description

Insert a picture into an excel file to specify the size and location.

 

3、 Attribute description

●Workbook object: the excel workbook object variable that has been opened.

●Worksheet: the name of a table in the Workbook: for example: "Sheet1".

●Picture path: select a picture file on your computer.

●left : the left distance between the picture and the window.

●top margin: the distance from the picture to the upper right corner of the window.

●image width: the width of the picture display.

●Picture height: the height of the picture display.

●Absolute path: Yes, relative to the computer disk, for example: C: \ \ RPA \ \ abc.png. No, relative to the project path, for example: \ \ abc.png.

 

3、 Use example

1. Execution logic

Open excel and insert a picture in Excel.

 

2. Output results