6万到7万怎么输excel表格

1.c#后台怎么把6万行数据EXCEL导入EXCEL

这是excel导入数据库的方法，也可以改成导入其他excel表中。

不废话，自己看，10W条数据导入时间不会超过1分钟。 string strCon = ""; string name = infor.FileName；//获取文件名 string xPath = infor.PostedFile.FileName； //获取完整客户端文件路径 string kzm = System.IO.Path.GetExtension(name); string newName = DateTime.Now.ToString("yyyyMMddHHmmss") + kzm; string filePath = Server.MapPath("~") + newName; infor.PostedFile.SaveAs(filePath); if (kzm.ToLower() == ".xlsx") { strCon = "Provider=MICROSOFT.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + "Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'"; } else if (kzm.ToLower() == ".xls") { strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'"; } else { ClientScript.RegisterStartupScript(GetType(), "msg", ""); System.IO.File.Delete(filePath); return; } OleDbConnection OleConn = new OleDbConnection(strCon); string sql = "SELECT * FROM [Sheet1$]"; DataSet ids = new DataSet(); try { OleConn.Open(); OleDbDataAdapter da = new OleDbDataAdapter(sql, strCon); da.Fill(ids, "sheet1"); OleConn.Close(); System.IO.File.Delete(filePath); } catch { ClientScript.RegisterStartupScript(GetType(), "msg", ""); System.IO.File.Delete(filePath); return; } try { string str_Connection = ConfigurationManager.ConnectionStrings[""].ConnectionString; SqlConnection orc = new SqlConnection(str_Connection); orc.Open(); System.Diagnostics.Stopwatch timer = new System.Diagnostics.Stopwatch(); SqlBulkCopy sqlBC = new SqlBulkCopy(orc); sqlBC.BatchSize = 100000; sqlBC.DestinationTableName = "gyshf"; sqlBC.ColumnMappings.Add("" + ids.Tables["sheet1"].Rows[0][0].ToString() + "", "gysid"); sqlBC.ColumnMappings.Add("" + ids.Tables["sheet1"].Rows[0][1].ToString() + "", "hftxt"); sqlBC.ColumnMappings.Add("" + ids.Tables["sheet1"].Rows[0][2].ToString() + "", "hftype"); sqlBC.ColumnMappings.Add("" + ids.Tables["sheet1"].Rows[0][3].ToString() + "", "hffj"); timer.Start(); sqlBC.WriteToServer(ids.Tables[0]); timer.Stop(); orc.Dispose(); ClientScript.RegisterStartupScript(GetType(), "msg", ""); } catch { ClientScript.RegisterStartupScript(GetType(), "msg", ""); } finally { }。