How to copy paste an image into an excel file and how to paste those images in different sheets of the same excel?

[Rashmi_N]

[aksh1yadav (AKSHAY YADAV)]

Hey @Rashmi_N

This link will guide you on this.

Create and Embed Objects in excel

We can create and embed objects like (.pdf, images, another excel sheets etc) in excel using hot keys automation. Flow Go to insert tab --> ALT + N Click on Text --> Key ZT Click on create Object --> Key J Click on create fro file – using click activity Click on Link to file --> ALT + L(Select Send window messages) Click on Display as Icon --> ALT + A (Select Send window messages) Attaching the workflow. excelObject.zip (252.8 KB)

Regards…!!
Aksh

[Rashmi_N]

Thank you. It worked

[sunita.baloda (sunita)]

Hey Aksh,

if i were to do the same thing in sheet2 of my existing excel workbook, how can i do so?

[ClaytonM]

@sunita.baloda
You could try the “Select Range” activity and select a cell on Sheet2 which will make it the active sheet.

[aksh1yadav (AKSHAY YADAV)]

if i were to do the same thing in sheet2 of my existing excel workbook, how can i do so?

you can use @ClaytonM advice. it is simple and effective because Selects a specified range from an Excel spreadsheet so it will make that activate.

Regards…!!
Aksh

[sunita.baloda (sunita)]

It works, Thanks ClaytonM adn Aksh. But i have one more concern. I am not able to change the icon image (in case of a doc file). What activity can i chose to pic doc icon.
Pls see below.

[balupad14 (Balamurugan)]

Hi ,
You can use the copy as image activity from the below package. it will save it as image file .

UiPath Go ! Edp Excel Activities

Excel functionality simplifier This package contains multiple custom activities that simplify processes in Excel. Scope - An activity specified workbook is needed and the Excel application is closed. The below activities can be executed: Copy As Picture - copy the selected cell range as an image. It performs the Copy As Picture functionality which is in the Excel workbook. SaveAs Workbook - save the excel file with a different format. Read Cell Formula - read the cell’s formula value Rega…

And use the Insert Picture in the below package.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains more than 30 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. Regards Balamurugan.S

Regards
Balamurugan.S

[PraloyMisra]

Dear Rashmi_N,
You can do it by using sending hotkey activity, for reference you can watch this tutorial:

[balupad14 (Balamurugan)]

Hi @Rashmi_N,

Using this “PasteClipboard” activity to paste inside any excel file.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel Activities. It is called “Paste Clipboard” . It paste data from the clipboard . That means you can copy the data anywhere(SAP,text editors and etc…) [image] I have attached the package in the thread begin. (It is a package before upload to UiPath Go). Thank you Balamurugan.S

Regards
Balamurugan.S

[Alapati_Harika]

Hi Can u helpme out on thiz screenshot activities
Wr I have a folder contains many screenshots.png now I have to paste into excel sheets like
One screenshot.png image paste to excel sheet1 at any postion it’s not mandatory
And
Second screenshot.png image paste to excel sheet2 soo on
…
…
Nth screenshot.png image paste to excel sheetn

I am so glad to say that if u help me out thz activities

Thanks
Harika