TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
diana onea
NA
8
17.1k
c# import Excel Files - error references
Jun 6 2011 1:41 PM
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();
}
}
}
Reply
Answers (
5
)
SilverLight Articles please...?
The given key was not present in the dictionary.