linqtoexcel

Linq to ExcelUse LINQ to retrieve data from Excel spreadsheets!

View the introduction videoBasic Examplevar repo = new ExcelQueryFactory();
repo.FileName = "pathToExcelFile";

var peopleWithSiblings = from p in repo.Worksheet()
where p.Siblings > 0
select p;Linq to Excel assumes the property names on the Person class match the column names in the worksheet named "Sheet1".

What if your class property names don't match the column names or the spreadsheet you're using is not named Sheet1? Then see the CustomizingLinqToExcel page.

Go to the GettingStarted page for a tutorial on implementing Linq to Excel in your project.

Need help? Send questions to the Discussion Group

Tags

csharp excel linq linqprovider net