读取excel

 1.读取excel内容，代码如下

public DataView Fill(string filename)
        {
            DataSet ds = new DataSet();
            OleDbConnection objConn =
              new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" +
                                  "Extended Properties=Excel 8.0;");
            objConn.Open();
            DataTable tblSchema = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            string tableName = tblSchema.Rows[0][2].ToString().Trim(); //获取 Excel 的表名，默认值是sheet1           
            string strSql = "select * from [" + tableName + "]";
            OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
            OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);
            myData.Fill(ds, tableName); //填充数据 
            objConn.Close();
            DataView dv = ds.Tables[tableName].DefaultView;
            return dv;
        }

 

2 无论是winform 还是wpf 中赋值dv即可绑定数据源。

wpf 中类似：dataview dview=dv;

this.datagrid.itemssource=dview,即可绑定