Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Open Excel URL and screenshot

Anasitani
6 - Meteoroid

Hi everyone,

 

I was wondering if it is possible to open a URL from an Excel file and then take a screenshot of the web page and upload it on a word document?

 

I saw something that included an "R" tag but i unfortunately don't have that.

 

Kind regards

Anas

1 REPLY 1
BrandonB
Alteryx
Alteryx

Do you need an actual image? If you pass the URL to a download tool you are able to extract the HTML of the webpage as it is which may accomplish what you need. If you truly need an image there are a couple of approaches discussed here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Display-static-webpage/td-p/75921 

 

Generally speaking, Alteryx can interact with APIs via the download tool, but to truly interact with a webpage beyond just pulling HTML you would want to use a Python tool to run something like Selenium. If you want to learn more about a Python approach within a workflow you can read more here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-Code-Tool-Web-Scraping-Dynamic-... 

 

You would be using a script like this: https://handyman.dulare.com/using-python-and-selenium-to-save-page-screenshots-to-word-document/ 

Labels
Top Solution Authors