Microsoft.Office.Interop.Excel.ApplicationClass has no constructor defined

Total Post:110

Points:776
C# 
C#
 9900  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. 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

      Modified On Apr-03-2018 05:59:59 AM

Answer