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?
Try this:
Excel._Application xlApp = new Excel.Application();