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?
Hi @alexis.mendoza ,
You can use ShortCut to insert the Picture.
- Use Excel applicxation scope with Write cell activity and mention the sheet name to add the Pictures.
- Use the Send Hotkey in this scope and key as ALT+nzipd
- 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.
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!!
I’d like to confirm which type of list you have,
List<String> (path to image file),
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)
I have a folder with images
It is not very clear to me how to specify in which cell the image should be pasted
Can you show me an example?
Can you try the following sample? This sample inserts images in Images folder to each cell of worksheet.
Sample20230727-1L.zip (11.5 KB)
HI @alexis.mendoza ,
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.
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.
I get the following error
Method name should be
select range activity not working.
the robot is pasting the images on top of the table.
Can you share your workbook and images? It’s no problem if dummy data.
Do you want the file or a screenshot?
File is good for us. We may be able to write workflow for it.
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.
Can you try the following sample? It works as the above 2.
Sample20230727-3L.zip (32.7 KB)