Skip to main content
Solved

How to paste images in Excel


Forum|alt.badge.img+2

Hi Team,

 

I need to paste images from local path to Excel in separate sheets and send that Excel to client.

I tried to use "Add picture from file to excel" bot from bot store but images getting disabled when image deleted or moved to another location.

So please suggest me how to insert images which should not disappear.

 

Thanks,

Lokesh 

Best answer by Elwait

Hello, Lokesh

 

A simple way is to use Key stroke Action to simulate “Ctrl + C” from Picture window, and “Ctrl + V” with Excel sheet window. 

Example:

 

you can add some steps like “Delay” or “Wait - for picture application window” to increase accuracy. 

 

Best regards

Elwait

 

 

View original
Did this topic help answer your question?

4 replies

Forum|alt.badge.img
  • Cadet | Tier 2
  • 2 replies
  • April 5, 2024

Hi ,

Did you get any solution on the above ? I have a similar requirement. 

Regards


Uzumaki
Forum|alt.badge.img+7
  • Navigator | Tier 3
  • 16 replies
  • September 11, 2024

I was able to make this work by using the screen recorder and automating the clicks (Insert > Pictures > Place in a cell > This device) and then automating the hot keys to type in the file location and file name of the picture. Using a variable to store the file location and name allows you to automate a process that uploads several different images.

There are two downsides to using the screen recorder to automate this process.

  1. If the window size is different (for example full screen versus a small 420x 420 resolution), the UI will change to accommodate the different screen sizes. When the UI changes, the button layout in excel will also change. This means that certain buttons that you may click in full screen will not be available when the screen UI is smaller, and this will cause the bot to fail because it can’t see all of the buttons that it is expecting to see
  2. If you run the bot on a device with a different version of excel than the one that you wrote your program in, the bot will fail. For instance, if you automate the button clicks of the excel enterprise edition and then try to run the bot on a device with excel 2019, the bot will fail because the layout is different between these two different versions of excel 

I am actively looking for alternative ways to implement automating images into excel because error number 2 that I listed above has caused my current bot to fail. Good luck


Forum|alt.badge.img+1
  • Cadet | Tier 2
  • 4 replies
  • Answer
  • September 12, 2024

Hello, Lokesh

 

A simple way is to use Key stroke Action to simulate “Ctrl + C” from Picture window, and “Ctrl + V” with Excel sheet window. 

Example:

 

you can add some steps like “Delay” or “Wait - for picture application window” to increase accuracy. 

 

Best regards

Elwait

 

 


Uzumaki
Forum|alt.badge.img+7
  • Navigator | Tier 3
  • 16 replies
  • September 12, 2024

Also, there is a bot in the bot store that does this job pretty well. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings