Excel数据导入DataGrid中

其实很简单，只要把excel做为数据源，绑定到DataGrid即可！

    private DataSet CreateDataSource()
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=E:\\项目文件\\Pu1_Erp\\practice\\zhangzs.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;
        }