C#从Excel中提取数据到DataGridView中显示出来

C#从Excel中提取数据到DataGridView中显示出来 以excel为数据源，建立连接，把excel中的数据读到dataset中，再赋给datagridview，显示出来。

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 excel
{
    public partial class Form1 : Form
    {
        public Form1（）
        {
            InitializeComponent（）;
        }

        private void Form1_Load（object sender EventArgs e）
        {
            string strConn = “Provider=Microsoft.Jet.OLEDB.4.0;“ + “Data Source=d:\\Book1.xls;“ + “Extended Properties=‘Excel 8.0‘“;
            OleDbConnection con=new OleDbConnection （strConn ）;
            OleDbDataAdapter da = new OleDbDataAdapter（“select * from [Sheet1$]“con ）;
            DataSet ds = new DataSet（）;
            da.Fill（ds）;
            dataGridView1.DataSource = ds.Tables[0]; 
        }

        private void dataGridView1_CellContentClick（object sender DataGridViewCellEventArgs e）
        {

        }

    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2013-05-06 09:13  excel\
     目录           0  2013-05-06 18:23  excel\excel\
     文件        2486  2013-05-06 16:20  excel\excel\Form1.Designer.cs
     文件        1001  2013-05-06 18:23  excel\excel\Form1.cs
     文件        5814  2013-05-06 16:20  excel\excel\Form1.resx
     文件         486  2013-05-06 09:13  excel\excel\Program.cs
     目录           0  2013-05-06 09:13  excel\excel\Properties\
     文件        1342  2013-05-06 09:13  excel\excel\Properties\AssemblyInfo.cs
     文件        2860  2013-05-06 09:13  excel\excel\Properties\Resources.Designer.cs
     文件        5612  2013-05-06 09:13  excel\excel\Properties\Resources.resx
     文件        1090  2013-05-06 09:13  excel\excel\Properties\Settings.Designer.cs
     文件         249  2013-05-06 09:13  excel\excel\Properties\Settings.settings
     目录           0  2013-05-06 09:13  excel\excel\bin\
     目录           0  2013-05-06 16:20  excel\excel\bin\Debug\
     文件        8704  2013-05-06 17:53  excel\excel\bin\Debug\excel.exe
     文件       24064  2013-05-06 17:53  excel\excel\bin\Debug\excel.pdb
     文件       14328  2013-05-07 09:14  excel\excel\bin\Debug\excel.vshost.exe
     文件         490  2009-06-11 05:14  excel\excel\bin\Debug\excel.vshost.exe.manifest
     文件        3756  2013-05-06 16:20  excel\excel\excel.csproj
     目录           0  2013-05-06 09:13  excel\excel\obj\
     目录           0  2013-05-06 17:53  excel\excel\obj\Debug\
     目录           0  2013-05-07 09:31  excel\excel\obj\Debug\TempPE\
     文件         180  2013-05-06 16:20  excel\excel\obj\Debug\excel.Form1.resources
     文件         180  2013-05-06 16:20  excel\excel\obj\Debug\excel.Properties.Resources.resources
     文件         838  2013-05-07 09:14  excel\excel\obj\Debug\excel.csproj.FileListAbsolute.txt
     文件         847  2013-05-06 16:20  excel\excel\obj\Debug\excel.csproj.GenerateResource.Cache
     文件        8704  2013-05-06 17:53  excel\excel\obj\Debug\excel.exe
     文件       24064  2013-05-06 17:53  excel\excel\obj\Debug\excel.pdb
     文件         905  2013-05-06 09:13  excel\excel.sln
     文件       15360  2013-05-07 09:25  excel\excel.suo