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.

Advertisements

Tags: , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: