How can i take the Screenshot and save it to Excel

[saneeth_kandukuri]

I had to take the Screenshot and save it to an excel of particular cell,example "C3"cell,i will be providing link.
Link :Calendar 2022
In the above link i want to take screenshot "january"and save it to excel in "C3"cell value…
example:
Can any one please help me in this regard… i will be very thankful.

[skini76]

You can use “take screen shot” activity, the image will be stored in a variable, you can write the content of the image to a jpg file and mention the link in excel OR insert the image in the excel.

[balupad14 (Balamurugan)]

Hi @saneeth_kandukuri,

To insert the picture you can use this activity. But it works at top and left positions

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.InsertImage - Inset a image into the excel sheet in specific top and let position. 2.InsertTableFormat - Inset the table format . 3.SetPassword - Can able to set and remove the password to the work book. Namespace [image] 1.InsertImage Properties [image] Activity [image] Samples SetPassword.zip (15.2 KB) 2.InsertImage Properties [image] Activity [image] Sample : InsertImage.zip (36.8 KB) 3.Inse…

Regards
Balareva

[Suman7 (Suman)]

Hi Saneeth,

Please find the attached workflow, which i have created as per your query.
You need to take care of the below mentioned 2 things:

1. Please change all the file paths as per your requirement which i have hard coded in the workflow .
2. The code is taking user input for inserting the image in excel. Please provide the cell address in that. Eg. “C1”

Let me know if you face any challenge in the code.

Regards,
SumanScreenshot_Workflow.zip (28.2 KB)

[saneeth_kandukuri]

it is getting error @Suman7 …can u give me screenshot of workflow…please.

[Suman7 (Suman)]

@saneeth_kandukuri

PFA the screenshots of the workflow.
Can you tell what error you are getting, so that i can help Screenshot_workflow.zip (260.4 KB)
you.