Excel and the World Wide Web Straight to the Point
Published on 1. February 2021
58 pages
978-1-61547-158-4 (ISBN)
Description
Unlock the Power of Web Data with Excel Do you have an Excel workbook that needs to regularly harvest data from a web page? Excel and the World Wide Web: Straight to the Point is for you! This guide covers various methods for getting data from the web, from VBA to Selenium to Power Query. Learn to navigate the complexities of getting data from the Modern Web and the lack of VBA support in Microsoft Edge. Discover how to: Automate web data extraction Integrate web data into Excel seamlessly Improve data analysis workflows Master VBA, Selenium, and Power Query For Excel users, business analysts, and data professionals looking to boost productivity and efficiency.
More details
Content
- Intro
- About the Author
- Acknowledgments
- Getting Started
- What is HTML?
- Performing Queries
- A static query
- A dynamic web query
- Querying with VBA
- Interacting with Sites without using a Browser
- What is JSON?
- Getting data from the Web programmatically
- Getting data from Web page elements
- Posting data over the Internet
- Authenticated requests
- Internet Explorer and VBA
- Transferring a Web table to the worksheet
- Working with events
- Introducing Selenium
- Installing Selenium
- Internet Explorer and Selenium
- Google Chrome and VBA
- Running JavaScript on a page
- Iframes and transferring tables without a loop
- Using XPath to find elements
- Microsoft Edge and VBA
- Finding elements by CSS selectors
- Downloading a file
- Creating a PDF file from scratch
- Wrapping up Selenium
- Power Query and the Web
- Connecting to a Web table - the direct way
- Connecting to a Web table - the long way
- Conclusion
- Index
