How to take screen shot and paste an image(Not as an object) in an excel of specific sheet(ex:sheet 3) when there are multiple sheets?

Help
,
1

Hello All ,

I attached the screen shot of my requirement.Please guide me how to approach.

Excel%20Screen%20shot
Excel%20Screen%20shot1358×598 537 KB

2

Hi Praveen
we can use it with the help of shortcut key as Use Alt+N+P use it with the help of type into and you need to iterate the number of sheet and call this shortcut key and insert the screenshot

Thanks
Ashwin S

3

can u explain me in briefly,
or else if any workflow will help:)

Cheers(y)

4

Hi @vr24

1.Use Excel application scope
2.use send hot key as Alt+N+p or type into.
3.Use for each item .wb sheets and use type into to do take screenshot

Thanks
Ashwin.S

5

Am already having screen shot and i have stored in particular folder,
from that folder i need to take that image and paste it in to excel.
if 10 images are there then i should take 10 excel sheet*

6

Hi use Excel application range
Store the variable as wb in workbook property
Use read range

For each item.wb.getSheets

Do the manipulations

Thanks
Ashwin.S

7

@praveenmallepu

BalaReva.Excel2.Activities.2019.0.0.nupkg (20.7 KB)

Install this package you will get "insert image " (activity) then you can insert your image in excel sheet as easily.

Thanks,
Aman Sheik

1 Like
8

Thanks Its working :slight_smile:

Regards,
VR Cheers

1 Like
9

You can do this by using send hotkey activity under excel application in scope, yuo ma refer following video link: