
Excel and the World Wide Web Straight to the Point
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.