读取excel进Datetable代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】读取excel进Datetable

作者:Dezai.CN / 发布于2011/5/4/ 782

<div>public static DataTable ExcelToDT(string filename, ref DataTable dt)
 { //先将EXCEL导入到数据库,一:先把EXCEL导入dateView,二:然后将dateView里的数据导入到数据库里面
 //EXCEL 的连接串
 string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
 "Data Source=" + filename + ";" +
 "Extended Properties='Excel 8.0;IMEX=1'";
 OleDbConnection objConn = new OleDbConnection(sConnectionString);
 objConn.Open();
 DataTable resultdt=objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object [4]{null,null,null,"TABLE"});
 objConn.Close();
 try
 {

 foreach (DataRow dr in resultdt.Rows)
 {
 //这里的删掉一些找不到的sheet,类似sheet1_
 if (dr["Table_Name"].ToString().IndexOf('_') < 0)
 {
 OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [" + dr["Table_Name"].ToString() + "]", objConn);
 OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
 objAdapter1.SelectCommand = objCmdSelect;
 DataSet objDataset1 = new DataSet();
</div>
<div> //建立EXCEL的连接
 objConn.Open();
 objAdapter1.Fill(objDataset1);
 objConn.Close();

 // DataGrid1.DataSource = objDataset1.Tables[0].DefaultView; //测试代码,用来测试是否能读出EXCEL上面的数据
 // DataGrid1.DataBind();
 //这里的tmpdt就是读到的当前sheet的dt了
 DataTable tmpdt = objDataset1.Tables[0];
 string fileName = ""
 fileName = filename.Substring(filename.LastIndexOf('\\') + 1);
 
 
 }

 }
 return dt;
 }
 catch (Exception e)
 {
 if (objConn.State == ConnectionState.Open)
 {
 objConn.Close();
 }
 string s = e.Message;
 Console.Write("插入操作出错");
 return null;

 }

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)