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,即可绑定