It's fun when an API is so awesome that it just makes you smile uncontrollably. That's how I felt after using Linq To Excel!
I dreaded the thought of coding against Excel and decided to search around for the best approach. StackOverflow served up a couple options, including LINQ to Excel. Now I like LINQ, so it naturally attracted my eye. The project is completely awesome! It let me extract data from multiple sheets in an excel workbook with just a few lines of code, and no direct dependency on Excel to be installed on the machine!
So, if you need to pull data out of Excel, look no further. You can even pull the package into your project via NuGet!