简单功能,固定的excel格式导入到DataSet中
如果需要导入到数据库,则对DataSet中的数据进行处理,在保存在数据库
1
#region
从excel中导入数据到ds
2 private DataSet BindDsFromExcel( string strFileDir)
3 {
4 string strConn;
5 strConn = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + strFileDir + " ;Extended Properties='Excel 8.0;HDR=False;IMEX=1' " ;
6 OleDbConnection OleConn = new OleDbConnection(strConn);
7 OleConn.Open();
8 sql = " SELECT * FROM [Sheet1$] " ;
9 OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql,OleConn);
10 DataSet OleDsExcle = new DataSet();
11 OleDaExcel.Fill(OleDsExcle, " aa " );
12 OleConn.Close();
13 return OleDsExcle;
14 }
15 #endregion
2 private DataSet BindDsFromExcel( string strFileDir)
3 {
4 string strConn;
5 strConn = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + strFileDir + " ;Extended Properties='Excel 8.0;HDR=False;IMEX=1' " ;
6 OleDbConnection OleConn = new OleDbConnection(strConn);
7 OleConn.Open();
8 sql = " SELECT * FROM [Sheet1$] " ;
9 OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql,OleConn);
10 DataSet OleDsExcle = new DataSet();
11 OleDaExcel.Fill(OleDsExcle, " aa " );
12 OleConn.Close();
13 return OleDsExcle;
14 }
15 #endregion