Insert several image in several excel cell

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

Hi @Soudios

Use click activity to insert image in excel cell

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

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
1 Like

I cannot use insert image at cell ?

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

@Soudios

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

1 Like

Hi @Soudios,

As @lakshman said , you can use this one

And also

Regards
Balamurugan.S

1 Like

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.

image

EntryMethodParameters: {strImagePath, strWorksheetName, strCell}

1 Like