linqtoexcel
https://github.com/paulyoder/linqtoexcel
C#
Use LINQ to retrieve data from spreadsheets and csv files
Triage Issues!
When you volunteer to triage issues, you'll receive an email each day with a link to an open issue that needs help in this project. You'll also receive instructions on how to triage issues.
Triage Docs!
Receive a documented method or class from your favorite GitHub repos in your inbox every day. If you're really pro, receive undocumented methods or classes and supercharge your commit history.
C# not yet supported22 Subscribers
Add a CodeTriage badge to linqtoexcel
Help out
- Issues
- Add ExcelQueryFactory constructor that accept Stream as param instead of file name
- LinqToExcel fails with external table format exception UNLESS I already have the spreadsheet open in excel
- Stream results
- Issues retrieving string values
- maping with specific sheet
- Multiple columns with the same name
- OLE DB Services not configurable (ITransactionLocal interface is not supported error)
- Certain "where" clauses fail
- Dates in format yyyy/mm/dd cause empty value to be returned.
- Question on filtering hidden rows
- Docs
- C# not yet supported