Mar 07, 2018 I have MS office 2010 installed, and I also have MS Visual Studio 2017 installed, but when I trying to add the reference Microsoft.Office.Interop.Excel.dll, It is no where to be found. I have tried reinstall Visual Studio, and still cannot find it. And Visual Studio forum said this is an office. Hi steven, I don't have Office 2010 and Visual.
- Microsoft.office.interop.excel.dll
- Microsoft.office.interop.excel 2007
- Microsoft.office.interop.excel 14
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. Microsoft.Office.Interop.Excel.dll is usually located in the 'c:WINDOWSassemblyGACMicrosoft.Office.Interop.Excel12.0.0.071e9bce111e9429c' folder. If you have additional information about the file, please share it with the FreeFixer users by posting a comment at the bottom of this page.
-->Install the Microsoft Office primary interop assemblies (PIAs) when you install Office.
![Microsoft Office Interop Excel Dll Version 12.0.0.0 Microsoft Office Interop Excel Dll Version 12.0.0.0](https://i.stack.imgur.com/J9l9j.png)
Note
Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model. Office Add-ins have a small footprint compared to VSTO Add-ins and solutions, and you can build them by using almost any web programming technology, such as HTML5, JavaScript, CSS3, and XML.
To install the PIAs when you install Office
- Ensure that you have a version of the .NET Framework that is no older than 2.0.
- Install Microsoft Office and make sure that the .NET Programmability Support feature is selected for the applications you want to extend (this feature is included in the default installation).WarningBy default, PIA's are embedded in your solution when you build it so you don't have to distribute PIAs to users as a prerequisite to using your VSTO Add-in or customization.
See also
roulettegenerous.netlify.com › █ Microsoft Office Interop Excel Dll Version 12.0.0.0 █
I unattached the.dll's and deleted, then added again but finding the correct version (in this case 12.0.0.0) and the problem was solved. Deleting from Bin directory should work but if not, search dll or reference name in the project, maybe in web.config and delete, it should update itself.
- Just-in-time (JIT) debugging instead of this dialog box. ***** Exception Text ***** System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
- Could not load file or assembly 'Microsoft.Office.Interop.Word, Version=12.0.0.0. Could not load file or assembly Microsoft.Office.Interop.Excel.dll-1.
I just downloaded MS Visual Studio 2010 solution and get that error.
Error 1 Assembly 'Microsoft.Office.Interop.Word, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' uses 'Microsoft.Vbe.Interop, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' which has a higher version than referenced assembly 'Microsoft.Vbe.Interop, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' c:PROJECTSUHelperAssembliesMicrosoft.Office.Interop.Word.dll AcceptService.Web
I have MS Office 2010 installed.I have reference to local copy of Microsoft.Office.Interop.Word.dll within project.
Any clue how to fix it?
DeveloperDeveloper
1 Answer
First I got this page that I assumed should be useful. But it was not. :(Anyway I put that link so it CAN be useful for someone else.
Second point was to use advice that I found here
So I navigated to http://www.microsoft.com/en-us/download/details.aspx?id=18249And installed Microsoft Office 2010 Primary Interop Assemblies Bootstrapper Package.
And finally I deleted
Microsoft.Office.Interop.Word.dll
reference in the project and added another one Visual Studio installs these copies of PIAs to the following locations:
On the development computer:
On the development computer:
%ProgramFiles%Microsoft Visual Studio 12.0Visual Studio Tools for OfficePIAOffice14
(or %ProgramFiles(x86)%Microsoft Visual Studio 12.0Visual Studio Tools for OfficePIAOffice14
on 64-bit operating systems)%ProgramFiles%Microsoft Visual Studio 12.0Visual Studio Tools for OfficePIAOffice15
(or %ProgramFiles(x86)%Microsoft Visual Studio 12.0Visual Studio Tools for OfficePIAOffice15
on 64-bit operating systems) Risk of rain 2 mac download.And yeah!!! Error gone! :)
Not the answer you're looking for? Browse other questions tagged .netvisual-studio-2010office-interop or ask your own question.
I have web-site that uses MS Excel files read/write.
I added related dll's to Bin folder of the site, and it works perfect on my local host (I think bacause I have installed MS Excel 2010 on my pc)
But when I uploaded it to remote pc and run the site, it throws an error:
Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
files in Bin folder are:
I've installed on remote pc 'Microsoft Office 2010: Primary Interop Assemblies Redistributable',http://www.microsoft.com/en-us/download/details.aspx?id=3508
But same error ocurrs.
Microsoft.office.interop.excel.dll
How to resolve this issue?
Thanks. Gira homeserver 4 vmware.
ihorkoihorko
4 Answers
I know that this thread is a little bit old but I had the same error and I solved it (it works in my project).
In my web.config file I had assemblies added:
<add assembly='office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'/>
and many other office assemblies.The thing I have done is that I have removed all the assemblies from web.config file and had added dlls as a reference - Microsoft.Office.Interop.Excel.dll in this case.
I am not an expert and I just thinking loudly that web.config file is trying to pull dll. file from C:Windowsassembly and if there if it could not be foud, returns error.
You don't have to install office or other unneccessary stuff on you server.
Hope this help someone.
ironcurtainironcurtain
you no need to install MS Office- 2010, Add Reference -> COM-> 'Microsoft office 12.0 Object Libaray'
its works for me.
Microsoft.office.interop.excel 2007
Correct procedure to use Excel in C# Projects is:
- Add reference to Excel Interop Library(Assembly)
- Add Excel in
using
section - Now use it in your coding.
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.a. 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.
b. If you don't find anything like
Microsoft.Office.Interop
THEN may be office not installed OR you have Office 2013 or later. For higher version you can add assembly by going into COM tab of add-reference windows and add Microsoft Excel {version-no} Object Library
. This will add the same.c. If you already have
Microsoft.Office.Interop.
in References with yellow-triangle-mark THEN remove it first.Microsoft.office.interop.excel 14
After that second step will totally work:
using Excel=Microsoft.Office.Interop.Excel;
And finally as a third step you can create Excel object by
Excel.Application xlApp = new Excel.Application();
.Adarsh RajputAdarsh Rajput