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/