If this project is internal to your company, and have control over what's installed, I would use the Microsoft Excel Object Library.
Excel & late binding works well too if your looking for generic automation.
Lots of examples out there for connecting to excel from .NET. With this method, you can take advantage of Excel's Named Ranges & formulas
cheers