string XLS_Path="";
string fileExtName = "";
string XLS_Name = "";
if (File1.PostedFile.ContentLength > 0)
{
XLS_Path = File1.PostedFile.FileName;
XLS_Name = XLS_Path.Substring(File1.PostedFile.FileName.LastIndexOf("//")).Replace("//", "").Replace(XLS_Path.Substring(File1.PostedFile.FileName.LastIndexOf(".")), "");
fileExtName = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.LastIndexOf("."));
string fullName = Server.MapPath("../Employee/FJ/") + XLS_Name + fileExtName;
string originalCategory = fullName.Substring(0, fullName.LastIndexOf(@"/"));
if (!Directory.Exists(originalCategory))
{
Directory.CreateDirectory(originalCategory);
}
File1.PostedFile.SaveAs(Server.MapPath("../Employee/FJ/") + XLS_Name + fileExtName);
XLS_Path = Server.MapPath("../Employee/FJ/") + XLS_Name + fileExtName;
string ConStr = System.Configuration.ConfigurationManager.AppSettings["ConnString"];
SqlConnection Conn = new SqlConnection(ConStr);
string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + XLS_Path + ";Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection(mystring);
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [" + XLS_Name + "$]", cnnxls);//Sheet1
DataSet myDs = new DataSet();
try
{
myDa.Fill(myDs);
}
catch
{
Response.Write("<script language=javascript>alert('数据导入失败,请检查Excel文档!');</script>");
return;
}
HttpContext.Current.Session["Ds"] = myDs;
File.Delete(XLS_Path);
if (myDs.Tables[0].Rows.Count <= 0)
{
Response.Write("<script language=javascript>alert('文件中可能没有数据,请检查后重新导入!');</script>");
return;
}
else
{
for (int i = 0; i < myDs.Tables[0].Rows.Count; i++)
{
//数据操作
model.XM = myDs.Tables[0].Rows[i]["姓名"].ToString().Trim();
//... ...
}
JScript.Alert("人员信息导入成功");
}
}
else
{
Response.Write("<script language=javascript>alert('请选择文件后再上传!!!');</script>");
return;
}