Why I Should Get This Error?The Name 'Excellibrary' Does Not Exist In The Current Context

Question

1.00/5 (1 vote)

See more:

C#

ASP.NET

How i Do resolved this Error???

Aaqib

Posted 21-Aug-14 20:38pm

Member 10994398

Add a Solution

Comments

Dilan Shaminda 22-Aug-14 2:46am

we can't predict what you have written in your source code.Please post your code here.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Answer 1 · 2014-08-21T20:45:00

I think you are getting this error to create a excel file

try to create excel like

C#

using Excel=Microsoft.Office.Interop.Excel;
using System.Reflection

public void CreateExcel( string fileName)
{
Object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Application m_objExcel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = m_objExcel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true);
Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets; ;
Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1];
m_objWorkBook.SaveAs(fileName, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
m_objWorkBook.Close(false,missing,missing);
m_objExcel.Quit();
}

Sergey Alexandrovich Kryukov · Answer 2 · 2014-08-22T06:08:00

You might 1) have no Excel installed; 2) it is installed, but you did not reference the interop assembly; 3) you referenced it, but you should use proper (fully-qualified, full) type name or use using directive to resolve its full name, with namespace.

I would rather advice to use Open XML SDL, then you won't need Office installed. Please see this CodeProject article:
Creating basic Excel workbook with Open XML[^].

Here are the Microsoft warnings against using interop in some settings:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^],
http://support.microsoft.com/kb/257757/en-us[^].

See also my past answers:
How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^],
Microsot office Interop[^].

If you still want to use Office Interop, please see my past answer: http://msdn.microsoft.com/en-us/library/dd264733.aspx[^].

—SA

Why I Should Get This Error?The Name 'Excellibrary' Does Not Exist In The Current Context

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0