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?
Loading
Cevdet AdanaliPosted Feb 28, 2013, 12:25 PM
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 kPosted Feb 28, 2013, 3:09 AM