Microsoft Office Interop Excel Dll Version 12.0.0.0
I am developing anASP.NET application and read data from excel by interop.In my local XP pro it is loaded Office 2007 and VS.NET 2008 and in GAC there is Microsoft Ofice Tools Common v9.0 Microsoft Ofice Tools Common2007 Microsoft Ofice Tools Excelv9.0 dlls. But when i publish it to Server (windows server 2003) it gives the error below. There is no Office 2007 or VS.NET only Framework 2.0. Hat should i do basicly. Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies.
Microsoft Office Interop Excel Download
The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040). Does the reference be there in reference dialog COM tab? 1001 arabian nights in telugu. To obtain the reference to interop with excel in your program, you have to install the PIA of the excel ( first install the excel).
If you have installed Office 2003, just follow the steps to add the reference: In VS, right click the references > Add Reference. > COM tab Then select 'Excel 11.0 Object Library' to add its PIA into your project, for more information see: Also check this kb article: And excel 2007(Excel 12.0) have similar steps. Discussions regarding Office Primary Interop Assemblies can be found at Excel programming discussions can be found at Hope this helps! Best regards, Yichun Chen Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have any feedback, please tell us.
The first step will work if you have Office(Excel) Installed in your PC. If not then install. Then add reference to Microsoft.Office.Interop.Excel of the version you need. If list doesn't shows the desire version then you may have another vision of Office with Excel installed. By The Way, you can use any. The Microsoft Office 2010 Primary Interop. Contains the Primary Interop Assemblies for Microsoft Office 2010. Microsoft.NET Framework 2.0.
Microsoft.office.interop.excel C#
Office primary interop assemblies • • 5 minutes to read • Contributors • • • • • • In this article To use the features of a Microsoft Office application from an Office project, you must use the primary interop assembly (PIA) for the application. The PIA enables managed code to interact with a Microsoft Office application's COM-based object model. When you create a new Office project, Visual Studio adds references to the PIAs that are required to build the project.
In some scenarios, you might need to add references to additional PIAs (for example, if you want to use a feature of Microsoft Office Word in a project for Microsoft Office Excel). This topic describes the following aspects of using the Microsoft Office PIAs in Office projects: • • • For more information about primary interop assemblies, see. Separate primary interop assemblies to build and run projects Visual Studio uses different sets of the PIAs on the development computer. These different sets of assemblies are in the following locations: • A folder in the program files directory.
These copies of the assemblies are used when you write code and build projects. Visual Studio installs these assemblies automatically. • The global assembly cache. These copies of the assemblies are used during some development tasks, such as when you run or debug projects. Visual Studio does not install and register these assemblies; you must do this yourself. Primary interop assemblies in the program files directory When you install Visual Studio, the PIAs are automatically installed to a location in the file system, outside of the global assembly cache. When you create a new project, Visual Studio automatically adds references to these copies of the PIAs to your project.
Visual Studio uses these copies of the PIAs, instead of the assemblies in the global assembly cache, to resolve type references when you develop and build your project. These copies of the PIAs help Visual Studio avoid several development issues that can occur when different versions of the PIAs are registered in the global assembly cache. Note Some assemblies are added to a project automatically when an assembly that references them is added. For example, references to the Office.dll and Microsoft.Vbe.Interop.dll assemblies are added automatically when you add a reference to the Word, Excel, Outlook, Microsoft Forms, or Graph assemblies. Primary interop assemblies for Microsoft Office applications The following table lists the primary interop assemblies that are available for Office 2013 and Office 2010.