Reference Excel 2007 component in C# Windows Application

I need some help on referencing an office component in C#3.5 win app .

How to add an Office2007/2010 Excel component in C#3.5 Windows Application toolbox and to use further as Drag and Drop.

using References unable to add the same (Excel2010/2007).

Please help in using the same.开发者_如何学Python

Please note that I doesn't need 11.0 version spreadsheet as reference.

You need Office PIA (primary interop assemblies) for referencing office application in your .NET app. Here is the re-distributable that you can use to get PIA for office 2007: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=59daebaa-bed4-4282-a28c-b864d8bfa513&displaylang=en

If you only use the component for IO, Use Excel Package plus.

That way you don't need Excel installed, and no com interoperability either.
http://epplus.codeplex.com/