Excel and the World Wide Web Straight to the Point. Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query - Helion
Tytuł oryginału: Excel and the World Wide Web Straight to the Point. Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query
ISBN: 9781837023103
stron: 58, Format: ebook
Data wydania: 2024-12-17
Księgarnia: Helion
Cena książki: 17,91 zł (poprzednio: 19,68 zł)
Oszczędzasz: 9% (-1,77 zł)
This book is a comprehensive guide for integrating web data into Excel, ideal for both beginners and experienced users. It begins by introducing essential concepts like HTML and JSON, laying the foundation for web data extraction. Readers start by performing static and dynamic web queries directly in Excel, building confidence in handling foundational tasks.
As the journey continues, the book explores advanced automation using VBA and Selenium. Readers learn to interact with web elements, handle authenticated requests, and navigate modern challenges like working with iframes, downloading files, and creating PDFs. Key techniques, including using XPath and CSS selectors, are explained to streamline data extraction. Chapters also address overcoming VBA’s limitations with modern browsers like Microsoft Edge, providing practical solutions.
In the final chapters, Power Query is introduced as a powerful tool for connecting and transforming web data. Readers explore both direct and advanced methods to integrate Excel with web sources efficiently. By the end, readers will master practical workflows, combining VBA, Selenium, and Power Query to automate and simplify web data extraction in Excel.
Osoby które kupowały "Excel and the World Wide Web Straight to the Point. Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query", wybierały także:
- Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
- Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
- Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
- Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)
- Od hierarchii do turkusu, czyli jak zarządzać w XXI wieku 58,64 zł, (12,90 zł -78%)
Spis treści
Excel and the World Wide Web Straight to the Point. Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query eBook -- spis treści
- 1. Getting Started
- 2. Interacting with Sites without using a Browser
- 3. Internet Explorer and VBA
- 4. Introducing Selenium
- 5. Google Chrome and VBA
- 6. Microsoft Edge and VBA
- 7. Power Query and the Web
- 8. Conclusion