Create an assembly of strongly typed objects from excel using BuildDTOsFromExcel. Each worksheet is mapped to a class.

Add the newly created assembly as a reference in your project along with ExcelMapper.dll to access excel as a collection of objects that implements IEnumerable giving you the feel of using Linq to Excel.

Using ExcelMapper: http://shashankshetty.wordpress.com/2009/05/09/using-excelmapper/

This is part of MVBA Law Commons.