C# -Excel interoperability

user_233927 0
Viewed 26187

I want to call Excel Sheet from C# 4.0 (VS 2010 Express Edition) .

When i declare ,

Microsoft.Office.Interop.Excel.ApplicationClass excel =
    new Microsoft.Office.Interop.Excel.ApplicationClass();

excel.Visible = true;

I receive error as

Interop type 'Microsoft.Office.Interop.Excel.ApplicationClass' cannot be embedded. Use the applicable interface instead.

What is the soultion ?

c#-4.0 excel
6 Answers

Here is a blog post that deals with that. Looks like you need to change

Microsoft.Office.Interop.Excel.ApplicationClass();

to 

Microsoft.Office.Interop.Excel.Application();
user_347960

You need to declare the variable as Microsoft.Office.Interop.Excel.Application, but instantiate it as Microsoft.Office.Interop.Excel.ApplicationClass.

user_1367900 
Excel.Application = new Excel.ApplicationClass();

Note the leading Excel.Application, not Excel.ApplicationClass.

Also note, this is straight out of the MSDN page for ApplicationClass.

JMD_567930

For MS Office 2016 you need to use the following no dramas 

Excel.Application oExcel = new Excel.Application();
user_11622740
Related