In part 1 of this blog post series we mentioned the most common approach to web scraping and its issues. We also made a small example on how to start web scraping with C#, Selenium and QueryStorm in Excel. Now we'll expand on the example from part 1 and create a more useful web...
Introduction
Web scraping is something that will come up sooner or later in a developer’s career – be it for a business requirement or for personal use. So, how do we tackle web scraping when the time comes?
First, let’s split the scraping task into three subtasks:
Getting the dataParsing the data to get our resultsOutputting the...
Excel doesn’t have much of a reputation as a developer tool. But imagine if instead of VBA you could use C#. Would this change things? I guess it depends. Admittedly, I’m a bit biased (since I wrote QueryStorm), but I find the combination of C# and a spreadsheet really useful. It lets me quickly...