Pasting screenshots to an Excel file

Hi everyone,

I have a question and would love the communities thoughts on how to solve our problem. The bot is meant to navigate to pages in two web apps and take screenshots of the web pages. Let’s say there are 2 images per web app per transaction, so 4 total screencaps per txn. Those screenshots are meant to be inserted/pasted into an Excel file where we are documenting this evidence.

Initially I am thinking we save the screenshots as a jpeg file to a folder for each txn (i.e., run all the screenshots and save them to a folder). Then, run an excel workflow that deposits these screenshots where they’re supposed to go.

What are your thoughts? How would you build this bot?

Hi @csanuik ,
I think this way is ok.
you can use use application scope go to web page,
take screen short to get image
save image
insert image to excel I think can use hot key
regards,
LNV

Thanks for your response LNV. Would you recommend taking all the screenshots and saving them. Then depositing / inserting into Excel? Or would you do take screenshot, saving screenshot, insert into Excel?

Hi @csanuik ,
two ways can be ok
but i think we should save them then insert later
we can get it and insert it right away but I think this way has a higher chance of getting an error
regards,
LNV

1 Like