How to retrieve data from Excel using linq?

Question

I like to retrieve the data from excel sheet using linq, I saw ExcelqueryFactory for that in some sites. I don't know the namespace or reference for that. I am using .net3.5 framework(visual studio2008). Is it possible to use it in .net3.5

possible duplicate of Is there a way to use LINQ against Excel? — Ian Mercer
– Ian Mercer, Commented Jan 5, 2011 at 6:17

ratty · Accepted Answer · 2011-01-05 05:46:15Z

7

I think ExcelQueryFactory come from .net framework 4.0 . We need to inculde dll for access that class in .net3.5.From below link we can get that.

http://code.google.com/p/linqtoexcel/source/browse/trunk/src/LinqToExcel/ExcelQueryFactory.cs?r=50

Below example code show how we retrieve from Excel using ExcelQueryFactory

var book = new ExcelQueryFactory("pathToExcelFile");
var australia = from x in book.Worksheet()
                where x["Country"] == "Aust"
                select new
                {
                   Country = x["Country"],
                   BookCode = x["Code"],
                   BookName = x["Name"]
                };

answered Jan 5, 2011 at 5:46

ratty

13.5k29 gold badges84 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Harald Coppoolse Over a year ago

The link goes to empty page (22 oct 2018)

JackD · Accepted Answer · 2011-01-05 16:30:22Z

-2

Try to obtain data to DataTable or any other collection using OleDb and process collection by LINQ. I can post or send obtaining sources bit later.

answered Jan 5, 2011 at 16:30

JackD

5974 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from Excel using linq?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related