把Excel文件中的数据读入到Gridview中

1、引用using System.Data.OleDb;

2、
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            //获得数据集，将数据进行绑定。
            GridView1.DataSource = CreateDataSource();
            GridView1.DataBind();
        }
    }
    private DataSet CreateDataSource()
    {
        string strConn;
        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=F://aaa.xls;" + "Extended Properties=Excel 8.0;";
        OleDbConnection conn = new OleDbConnection(strConn);
      
        OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
   
        DataSet myDataSet = new DataSet();
        myCommand.Fill(myDataSet);
        return myDataSet;
    
    }
    //选定路径；在[]内选定工作薄。 

3、前台页面：

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField DataField="userid" HeaderText="id" />
                <asp:BoundField DataField="username" HeaderText="name" />
            </Columns>
        </asp:GridView>

4、Excel中的文件类似于：

    userid                         username

      1                                    aaa

       2                                   bbb

       3                                   ccc