CODEWITHSUNDEEP
.netexcelinterop
AJ.
AJ.

Reputation: 13761

.NET Error: The dependency 'Microsoft.Office.Interop.Excel' could not be found

My colleague has written a DLL which drives Excel.
When I reference his DLL in my .NET app, I get a warning:

The dependency 'Microsoft.Office.Interop.Excel' could not be found.

My app will compile.
However, when I get to the bit that uses my colleague's DLL to access Excel, an exception is thrown, with the message above.

We should have identical setups: Windows XP Pro SP3, VS2003, .NET 1.1, Office 2003

My problem seems similar to this question, but I don't know if it's the same.

Any help or suggestions gratefully received!

Update:

Thanks for answers so far!

I have not added an explicit reference to Microsoft.Office.Interop.Excel.
Surely I shouldn't have to?
However: When I tried to add this reference, I cannot find Microsoft.Office.Interop.Excel in the Add Reference dialog.

Presumably this means that I am missing a DLL?
... But I don't understand how that could happen?!

Update (fixed):

@ConcernedOfTunbridgeWells has the answer that fixed this for me: installing the Primary Interop Assemblies.

Upvotes: 9

Views: 21202

Answers (5)

ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells

Reputation: 66732

You may need to install the Primary Interop Assemblies for Office, which can be downloaded from Here. Depending on the order that you install Visual Studio and Office they may not be installed by default.

Upvotes: 12

Emmanuel
Emmanuel

Reputation: 1

I just solved it as follows:

  • First I go to Add Reference
  • Click COM on the top left part of Add Reference window.
  • Find Microsoft Excel 15.0 Object Library.
  • Or maybe it may not be 15.0, just object library.

I am using Microsoft Office 2013 and Microsoft Visual Studio 2012.

Upvotes: 0

nathanchere
nathanchere

Reputation: 8098

I had the same problem trying to run the "official" F# samples on CodePlex. Projects were referencing interop V11. I removed the references and went to add them again, noticing I had V9, V12 and V14. I added V12 and everything worked fine without any further changes.

Something you might want to try before installing yet another interop version.

Upvotes: 0

Sijin
Sijin

Reputation: 4550

Ask your colleague to send you the Interop.Excel.dll file that he has in his bin folder. Alternatively as Jon has suggested above you can add a reference to Microsoft Excel library from the COM tab of the Add Reference dialog.

Upvotes: 2

Jon Skeet
Jon Skeet

Reputation: 1504172

Have you explicitly added a reference to Microsoft.Office.Interop.Excel in your project?

Upvotes: 3

Related Questions