Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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