Error for ExcelDataReader

c# namespaces exceldatareader
Rituja Nashikkar picture Rituja Nashikkar · Jul 28, 2017 · Viewed 13.5k times · Source

I am doing a project in C# and I have downloaded ExcelDataReader from codeplex and added it to my project reference. There is an error in namespace 'using Excel;' though I have added Excel, Excel.4.5, Microsoft.Office.Interop.Excel to my project references. I'm getting error where I have written 

 IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

The errors are quoted below:

The type or namespace name 'ExcelDataReader' could not be found (are you missing a using directive or an assembly reference?) The name 'ExcelReaderFactory does not exist in the current context

How to deal with these errors?
Thank you in advance.

PS:- I have added 'using Excel = Microsoft.Office.Interop.Excel' directive as well.

Answer

Michał Turczyn picture Michał Turczyn · Jul 28, 2017

Go to Project -> Manage NuGet Packages..., in opened window select Browse tab and type Excel Data Reader, install it, at the top of your class add using Excel. Then you will be able to use interface IExcelDataReader.

Here is the source:

https://forums.asp.net/t/1981566.aspx?The+type+or+namespace+name+IExcelDataReader+could+not+be+found

Related questions

Getting "type or namespace name could not be found" but everything seems ok?

I'm getting a: type or namespace name could not be found error for a C# WPF app in VS2010. This area of code was compiling fine, but suddenly I'm getting this error. I've tried removing the Project Reference and the …

Read More
Should 'using' directives be inside or outside the namespace?

I have been running StyleCop over some C# code, and it keeps reporting that my using directives should be inside the namespace. Is there a technical reason for putting the using directives inside instead of outside the namespace?

Read More
Getting all types in a namespace via reflection

How do you get all the classes in a namespace through reflection in C#?

Read More