★★★★★★★★★★★★★★★ The Microsoft Office 2010 Primary Interop Assemblies (PIA) Redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for Microsoft Office 2010 products. The redistributable contains the PIAs for the following products: Microsoft Access 2010 Microsoft Excel 2010 Microsoft InfoPath 2010 Microsoft Outlook. Dec 01, 2011 To install the Office 2010 Primary Interop Assemblies, click the Download button, then click Save and select a location for PIARedist.exe on your computer. Run the executable to extract the O2010pia.msi file. Use one of the following installation methods to install O2010pia.msi: Double-click the O2010pia.msi file.
- Microsoft.office.interop.excel
- Microsoft Office 2013 Interop Assemblies Download
- Ms Office 2010 Primary Interop Assemblies Download
Microsoft.office.interop.excel
When you create a new Office project, Visual Studio automatically adds references to the Microsoft Office primary interop assemblies (PIAs) that are required to build your project. You must add references to other PIAs in the following scenarios:
You want to use features of other Microsoft Office applications in your project. For example, you might want to use features of Microsoft Office Excel in a project for Microsoft Office Word.
You want to automate Microsoft Office applications that do not have dedicated projects in Visual Studio, such as Microsoft Office Access.
Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects. See Features available by Office application and project type.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Personalize the IDE.
To add a reference to a primary interop assembly
Open your Office project and select the project name in Solution Explorer.
On the Project menu, click Add Reference.
On the Framework tab, select the PIA you want in the Component Name list. For more information about the available Microsoft Office primary interop assemblies, see Office primary interop assemblies.
If the project targets the .NET Framework 4 or later, the Embed Interop Types property for the assembly reference is set to True by default. By using this setting, your solution does not require the PIA on end-user computers. For more information, see Design and create Office solutions.
Note
In Office projects, always add references to Office PIAs by using the .NET tab of the Add Reference dialog rather than the COM tab. For more information, see Office primary interop assemblies.
Click OK.
The assembly name appears in the References folder of Solution Explorer.