Replacing VBA with C#?
I spend a fair amount of time writing code in C#, which I enjoy. I occasionally wish I could use C# inside other applications.
One application where I think C# would fit right in is Excel, as a replacement for VBA. VBA is a bit (a lot) behind the times and Microsoft...
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...
A few years ago, I set out to build a small Excel plugin to help out my girlfriend at the time. I ended up building a full-blown IDE over the course of four years and spent the winter in Poland in a startup accelerator.
How did this happen? As with many great endeavors of man,...