This project has moved and is read-only. For the latest updates, please go here.

Joining date from multiple Worksheets using LINQ

Mar 22, 2013 at 3:54 PM
Is there any way to join data from multiple worksheets using LINQ?
All worksheets have a column that serves as a key.
Mar 23, 2013 at 12:26 AM
It may be more efficient to query the data within Excel using SQL queries and VBA macros unless you have a specific need to get the data outside of Excel to manipulate in a .NET program using Epplus.

Have a look at this stackoverflow.com thread http://stackoverflow.com/questions/8756802/excel-function-to-make-sql-like-queries-on-worksheet-data