将Excel导入DataGridView

最新推荐文章于 2014-01-21 16:30:00 发布

iteye_15968

最新推荐文章于 2014-01-21 16:30:00 发布

阅读量192

点赞数

文章标签： Excel Microsoft Windows

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Excel { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string Connecstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.xls;Extended Properties='Excel 8.0;HDR=YES; IMEX=1'"; OleDbConnection Con = new OleDbConnection(Connecstr); Con.Open(); string strCommand = "SELECT * FROM [Sheet1$]"; OleDbDataAdapter adapter = new OleDbDataAdapter(strCommand,Con); DataSet DS = new DataSet(); adapter.Fill(DS,"[Sheet1$]"); dataGridView1.DataMember = "[Sheet1$]"; dataGridView1.DataSource = DS; Con.Close(); } } }