Archive | Excel RSS for this section

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.