How to insert images into excel cells

Help Activities
, , ,
1

I have the following problem, I have a list of images, I want to enter them in order in an excel file, one image per cell, how can I do this?

2

Hi @alexis.mendoza ,
You can use ShortCut to insert the Picture.

  1. Use Excel applicxation scope with Write cell activity and mention the sheet name to add the Pictures.
  2. Use the Send Hotkey in this scope and key as ALT+nzipd
  3. Use Type into Activity and Indicate the Insert image pop-up and pass the Path with the file name and click ok or enter as a shortcut.
    Regard,
1 Like
3

Hi @alexis.mendoza
While extracting the tabular data, change the setting preference of the image to url.so,that all the images will get into png format and then write into excel

Hope it helps!!

4

Hi,

I’d like to confirm which type of list you have, List<String> (path to image file), List<Bitmap> or List<UiPath.Core.Image> etc?
Basically, we can paste image to each cell via Clipboard, for example.

FYI, the following is similar topic for StudioX (Please use auto-translate tool)

Regards,

1 Like
5

I have a folder with images

6

It is not very clear to me how to specify in which cell the image should be pasted

Can you show me an example?

7

Hi,

Can you try the following sample? This sample inserts images in Images folder to each cell of worksheet.

image
image1028×2022 143 KB

Sample20230727-1L.zip (11.5 KB)

Regards,

1 Like
8

HI @alexis.mendoza ,
My solution

image
image542×762 17.2 KB

Regards,

9

my process downloads one image at a time … it is inside a click for each in each psada it will download an image and insert it to a cell of a book, this with each turn.

The downloaded image is always replaced.

10

Please modify the above sample for your requirement.
I guess you already have loop and can use it instead of the above ForEach.
And if you know image file which you downloaded, use it as argument of Bitmap constructor as the following.

new System.Drawing.Bitmap(DownloadImagePath)

Regards,

11

I get the following error
image

12

HI,

Did you set Parameter property? (Please also check the above sample project.)

image
image1337×528 45.3 KB

Regards,

13

Yes, check it out, I have it exactly the same

image
image1657×478 54.5 KB

Do I have to install any other dependencies?

14

HI,

Method name should be SetImage.

Regards,

15

select range activity not working.
the robot is pasting the images on top of the table.

16

HI,

Can you share your workbook and images? It’s no problem if dummy data.

Regards,

17

Do you want the file or a screenshot?

18

Hi,

File is good for us. We may be able to write workflow for it.

Regards,

19

Nuevo Hoja de cálculo de Microsoft Excel.xlsx (1.9 MB)

The way to get the images is as follows.

1 in each row there is an image url so the bot navigates to that image and it awaits with the name “Example”

2 paste the image into the excel file in the row corresponding to its URL.

3 Repeat the process replacing the previously downloaded image.

20

Hi,

Can you try the following sample? It works as the above 2.

image
image1028×2371 175 KB

Sample20230727-3L.zip (32.7 KB)

Regards,