Namespace error OfficeOpenXML EPPlus

c# .net visual-studio visual-studio-2012 epplus
user99999991 picture user99999991 · Jul 9, 2013 · Viewed 55.8k times · Source

I'm having difficulty setting up EPPlus in Visual Studio 2012.

using OfficeOpenXML;
The type or namespace name 'OfficeOpenXML' could not be found(are you missing a using directive or an assembly reference?)

Now I tried 2 different ways to set EPPlus up.

I manually added a Project->Add Reference to the Epplus.dll file in my documents.

I also tried to use NuGet package manager console: PM> Install-Package EPPlus

I clearly see EPPlus is added to the References in my project, but the namespace for OfficeOpenXML is not added. How do I add this namespace with the EPPlus reference?

Answer

Jon Skeet picture Jon Skeet · Jul 9, 2013

I believe this is just a problem of casing. This:

using OfficeOpenXML;

should be:

using OfficeOpenXml;

Note the lower case "M" and "L" at the end.

I say that based only on the sample code...

Related questions

Package requires NuGet client version '2.12'

I am trying to install 'WindowsAzure.Storage 8.0.1' in visual studio 2012, but getting the error package requires NuGet client version '2.12' or above, but the current NuGet version is '2.8.60318.667'. on running command "Install-Package NuGet.Client" Attempting to …

Read More
Visual studio compiles fine but still shows red lines

I am using VS 2012 and it was working all fine until I started observing some funny behavior. When I open my code it shows red Underlines which we usually see when there is an error in our code. Surprisingly, code …

Read More
Weird: C# Type or Namespace name could not be found - Builds successfully

I have a weird error showing up in my project when it is open in the VS2012 IDE. Everywhere where I make use of another referenced project it suddenly says "Type or Namespace name could not be found". And by "…

Read More