1
I Use This!
Low Activity
Analyzed 4 days ago. based on code collected 4 days ago.

Project Summary

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

In a Nutshell, linqtoexcel...

MIT License
Permitted

Commercial Use

Modify

Distribute

Private Use

Sub-License

Forbidden

Hold Liable

Required

Include Copyright

Include License

These details are provided for information only. No information here is legal advice and should not be used as such.

All Licenses

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    search using multiple tags to find exactly what you need
  • ...
    in 2016, 47% of companies did not have formal process in place to track OS code
  • ...
    you can subscribe to e-mail newsletters to receive update from the Open Hub blog

Languages

Languages?height=75&width=75
C#
99%
XML
1%

30 Day Summary

Sep 19 2018 — Oct 19 2018

12 Month Summary

Oct 19 2017 — Oct 19 2018
  • 71 Commits
    Up + 62 (688%) from previous 12 months
  • 4 Contributors
    Up + 2 (100%) from previous 12 months