c# import Excel Files - error references

diana onea

15y8.8kC#

Hello

I have a small problem. I want to import Excel files using C# but when i declare a variable like this xlsApp = new Excel.ApplicationClass() I receive this error : The type or namespace name 'ApplicationClass' does not exist in the namespace 'Excel' (are you missing an assembly reference?.

I added the following references : Microsoft Excel 12.0 Object Library, Microsoft Excel 5.0 Object Library and Microsoft.Office.Interlop.Excel and it stil dosen`t work.

This is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using Excel;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace PC_Management3

{

public partial class BrowseExcel : Form

{

public BrowseExcel()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

//open file

OpenFileDialog fdlg = new OpenFileDialog();

fdlg.InitialDirectory = @"d:\";

fdlg.Filter = "All files (*.xls)|*.xls|All files (*.*)|*.*";

fdlg.FilterIndex = 2;

fdlg.RestoreDirectory = true;

if (fdlg.ShowDialog() == DialogResult.OK)

{

textBox1.Text = fdlg.FileName;

}

//excel stuff

Excel.Application xlsApp;

Excel.Workbook xlsWorkbook;

Excel.Worksheets xlsWorksheet;

xlsApp = new Excel.ApplicationClass();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
As I said, your code works for me.

There are basicly two ways to add a reference for Excel; the newer and the older ways. The older way is done from the COM tab; the newer way is from the .Net tab. I get confused about which is which. My first reply in this thread is consistent with the new way. You are probably too quick to conclude that it does not work.

See Accessing Microsoft Office InterOP Objects using C# 4.0 for a good article about how to do it. Except it uses dynamic and I suggest not using dynamic.
diana onea15y ago
Already did....and it`s the same :(....
Sam Hobbs15y ago
Perhaps you are getting the error due to guessing about what to do and added too many references. Your code woked for me when I added the statements I specified. I suggest removing all the references for Excel and then reading an article in this web site about Excel Interop.
diana onea15y ago
Hi Sam,

Thank you for your reply. I already added that reference. And when I use using Excel = Microsoft.Office.Interop.Excel; I receive this errors :

Namespace '' contains a definition conflicting with alias 'Excel' - 4 times for the following lines

Excel.Application xlsApp;
Excel.Workbook xlsWorkbook;
Excel.Worksheets xlsWorksheet;

xlsApp = new Excel.ApplicationClass();

Interop type 'Microsoft.Office.Interop.Excel.ApplicationClass' cannot be embedded. Use the applicable interface instead. - for this line :

xlsApp = new Excel.ApplicationClass();
Sam Hobbs15y ago
Did you look at the articles in this web site? There are many useful articles; many about Excel. Please read those before asking for help in a forum.

Do you have a using for "Microsoft.Office.Interop"? If not then put that in. Then add the following line after the using statements:

using Excel = Microsoft.Office.Interop.Excel;

Please be sure to call xlsApp.Quit() if the xlsApp object is valid because if you don't then an instance of Excel will continue after your program exits.