将Excel导入DataGridView

将Excel导入DataGridView

view plaincopy to clipboardprint?
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();  
        }  
    }  
}  
 



本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/vwfkyy/archive/2008/11/30/3414843.aspx