How Get Multiple Columns From Excel To Lisboxes in C#

Question

Hi,

I have an Excel file 2007. There are 3 columns.Like This:

No Name Grade
1 Ali 100
2 Denis 85
3 John 70

I wanna get this excel columns into Listboxes with two buttons named "Browse" and "Load".

Column No to Listbox1
Column Name to Listbox2
Column Grade to Listbox3

How can i do this?

Cevdet Adanali · Answer

Thank you for answer. I checked the link. But I could not... I send my file. Maybe someone can help me... Here is my codes : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace ColumnsFromExcelToListboxes { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void btnBrowseExcelFile_Click(object sender, EventArgs e) { OpenFileDialog fdlg = new OpenFileDialog(); fdlg.Title = "C# Corner Open File Dialog"; fdlg.InitialDirectory = @"c:\"; fdlg.Filter = "All files (*.xlsx)|*.xlsx|All files (*.xlsx)|*.xlsx"; fdlg.FilterIndex = 2; fdlg.RestoreDirectory = true; if (fdlg.ShowDialog() == DialogResult.OK) { textBox1.Text = fdlg.FileName; } } private void btnLoadData_Click(object sender, EventArgs e) { // I don't know what codes must i write here to load data from 3 Excel columns } private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { } private void listBox2_SelectedIndexChanged(object sender, EventArgs e) { } private void listBox3_SelectedIndexChanged(object sender, EventArgs e) { } } }

brunda k · Answer

http://www.aspforums.net/Threads/505299/Read-the-Column-Values-of-the-Header-Row-in-Excel-2003-and-2007-file-C/