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 }
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 }