private void DoImpUser() { string FileName = RequestData.Get("FileId") + ""; string SurveyId = RequestData.Get("SurveyId") + ""; string InputType = RequestData.Get("InputType") + ""; //导入的类型 FileName = MapPath("/Document/") + FileName; ComUtility Ut = new ComUtility(); DataTable dt = Ut.ExcelToDataTable(FileName); }
/// <summary> /// Excel转成DataTable /// </summary> /// <param name="FileName">文件全路径</param> /// <returns></returns> public DataTable ExcelToDataTable(string FileName) { string Extend = string.Empty; //文件扩展名 string strConn = string.Empty; if (FileName.Contains(",")) { FileName = FileName.Substring(0, FileName.Length - 1); Extend = FileName.Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries)[1]; } else { Extend = FileName.Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries)[1]; } strConn = ComUtility.GetConStr(FileName); //获取Excel连接字符串 OleDbConnection XLSconn = new OleDbConnection(strConn); OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", XLSconn); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { try { if (File.Exists(FileName)) { File.Delete(FileName); } } catch { } } return(dt); }