MICROSOFT.OFFICE.INTEROP.EXCEL.APPLICATIONCLASS HAS NO CONSTRUCTOR DEFINED

Jeet Verma

Total Post:110

Points:776
Posted by  Jeet Verma
C# 
C#
 8906  View(s)
Ratings:
Rate this:

I tried to follow How to open an Excel file in C# tutorial, i.e. added a reference on the Com tab to Microsoft Office 14.0 Object Library and tried to compile code:

using Excel = Microsoft.Office.Interop.Excel;

//...

Excel.Application xlApp;

Excel.Workbook xlWorkBook;

Excel.Worksheet xlWorkSheet;

xlApp = new Excel.ApplicationClass();//error here

//...

and faced a compile-time error, saying

There is no constructor defined for Microsoft.Office.Interop.Excel.ApplicationClass type.

What am I missing?

  1. ezra heywood

    Post:145

    Points:1019
    Re: Microsoft.Office.Interop.Excel.ApplicationClass has no constructor defined

    Hi Jeet,

    Use the following to open it:

    xlApp = CreateObject("Excel.Application");

    CreateObject creates and returns a reference to a COM object

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!