Excel and the World Wide Web Straight to the Point : Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query
Learn to automate web data extraction in Excel using VBA, Selenium, and Power Query. Master static and dynamic queries, JSON parsing, and browser automation, tackling modern web challenges seamlessly. Key Features: Practical techniques for web-to-Excel integration using VBA, Selenium, and Power Quer...
Gardado en:
| Autor Principal: | |
|---|---|
| Formato: | Livre numérique |
| Idioma: | Anglais |
| Publicado: |
Birmingham :
Packt Publishing
2024.
Paris : Cyberlibris |
| Acceso en liña: | Accès Université d'Orléans et IFPM |
| Nota: |
Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837023103.jpg Cyberlibris (ScholarVox) corpus Informatique |
| Autres localisations: | Voir dans le Sudoc |
| Edition sous un autre format: | • Excel and the World Wide Web Straight to the Point, Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query, Eduardo N. Sanchez, Birmingham, Packt Publishing, 2024, 1 vol. (58 p.), 978-18-3702-311-0 |
| LEADER | 03710nam a22002177a 4500 | ||
|---|---|---|---|
| 001 | 1289565 | ||
| 008 | 250324s2024 xxg ||| |||| 00| 0 eng d | ||
| 009 | PPN283883456 | ||
| 020 | |a 9781837023103 | ||
| 041 | 0 | |a eng | |
| 100 | 1 | |a Sanchez, Eduardo N. | |
| 245 | 1 | 0 | |a Excel and the World Wide Web Straight to the Point : |b Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query |c Eduardo N. Sanchez. |
| 260 | |a Birmingham : |b Packt Publishing. | ||
| 260 | |a Paris : |b Cyberlibris, |c 2024. | ||
| 500 | |a Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837023103.jpg | ||
| 500 | |a Cyberlibris (ScholarVox) corpus Informatique | ||
| 506 | |a L'accès en ligne est réservé aux établissements ou bibliothèques ayant souscrit l'abonnement. Cyberlibris | ||
| 520 | |a Learn to automate web data extraction in Excel using VBA, Selenium, and Power Query. Master static and dynamic queries, JSON parsing, and browser automation, tackling modern web challenges seamlessly. Key Features: Practical techniques for web-to-Excel integration using VBA, Selenium, and Power Query ; Clear solutions for handling modern web challenges, including browser limitations and JSON data ; Comprehensive coverage of static queries, dynamic queries, and advanced browser automation. Book Description: 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. What you will learn: Perform static and dynamic web queries directly in Excel ; Automate browser interactions with Selenium and VBA ; Extract and parse JSON data for web-based Excel workflows ; Integrate Power Query to manipulate and load web data efficiently ; Handle authenticated web requests and modern browser challenges ; Apply advanced XPath and CSS selectors for precise data scraping. Who this book is for: This book is designed for data analysts, Excel enthusiasts, and developers who need to integrate web data with spreadsheets. A basic understanding of Excel and VBA is required, while prior experience with Power Query or Selenium is helpful but not mandatory | ||
| 776 | 0 | |t Excel and the World Wide Web Straight to the Point |o Mastering Web Data Extraction in Excel with VBA, Selenium, and Power Query |f Eduardo N. Sanchez |c Birmingham |n Packt Publishing |d 2024 |p 1 vol. (58 p.) |z 978-18-3702-311-0 | |
| 856 | 4 | |5 452349901:84685628X |u https://ezproxy.univ-orleans.fr/login?url=https://univ.scholarvox.com/book/88966989 |z Accès Université d'Orléans et IFPM | |
| 997 | |0 1289565 |1 Livre numérique |a Ressource numérique |b INSA |b ENSA |c 0/Bibliothèque numérique/ |c 1/Bibliothèque numérique/ScholarVox (ebooks)/ | ||