Insert several image in several excel cell

[Soudios (Sou)]

Want to insert image 1 in cell 1, image 2 in cell2…

[aanandsanraj (Anandraj Rajendran)]

Hi @Soudios

Use click activity to insert image in excel cell

[Soudios (Sou)]

Yes but it takes me a lot of time, how can i automise that ?

[aanandsanraj (Anandraj Rajendran)]

Try the following steps

• Excel scope - provide the path
• Write cell - give cell name and provide value as “string.empty”
• Send hot key - use Alt+n+p
• Type into - provide the image path in the filename textbox
• click - click the insert button

[Soudios (Sou)]

I cannot use insert image at cell ?

[aanandsanraj (Anandraj Rajendran)]

You can add image into the cell by using above steps.

[lakshman (Ganta lakshman)]

@Soudios

Use Insert Image at Cell activity under Balareva.Excel.Activities package to do this.

UiPathGo - BalaReva Excel Activities

Hi , I have included a new activity in the version 19.0.0 called InsertImage at cell. I don’t want to explain it. you can understand the meaning of this activity by the name. [image] Regards Balamurugan.S

[balupad14 (Balamurugan)]

Hi @Soudios,

As @lakshman said , you can use this one

UiPathGo - BalaReva Excel Activities

Hi , I have included a new activity in the version 19.0.0 called InsertImage at cell. I don’t want to explain it. you can understand the meaning of this activity by the name. [image] Regards Balamurugan.S

And also

Regards
Balamurugan.S

[eythor.borgthorsson (Eyþór Óli)]

5 sec execution:

Save this vba snippet in a .txt file:

Sub InsertImageToExcel(imagePath,workSheetName, cell)
	  Set myDocument = Worksheets(workSheetName)
	  myDocument.Shapes.AddPicture _
 imagePath, _
 False, True, Range(cell).Left, Range(cell).Top, -1, -1
End Sub

Use Invoke VBA inside an Excel Application Scope.

EntryMethodParameters: {strImagePath, strWorksheetName, strCell}