Querying Excel worksheets with LINQ
A while ago I was looking for a way to query Excel with LINQ. I needed a simple solution that allows me to query tables in Excel worksheets in a tool like LINQPad.
I couldn’t find a solution which fitted my needs so I decided to write my own ExcelProvider.
Today I posted a small article that describes how I have implemented my ExcelProvider and it demonstrates its features by giving an example of a LINQ query and the result in LINQPad.
You can read the full article or download all sources at my website.