EXCEL导入导出

导入
 /**////'遍历File表单元素
      HttpFileCollection files  = HttpContext.Current.Request.Files;

     
      /**//// '状态信息
      System.Text.StringBuilder strMsg = new System.Text.StringBuilder();
      int x = 0;
      string message = "";
      ErrorReport erp = new ErrorReport();
      ErrorReport report = new ErrorReport();
      strMsg.Append("上传的文件分别是：<hr color=red>");
     try
      {
        for(int iFile = 0; iFile < files.Count; iFile++)
        {

            /**////'检查文件扩展名字
            HttpPostedFile postedFile = files[iFile];
            string fileName, fileExtension;
            fileName = System.IO.Path.GetFileName(postedFile.FileName);
          
            if (fileName != "")
            {
                fileExtension = System.IO.Path.GetExtension(fileName);
                // strMsg.Append("上传的文件类型：" + postedFile.ContentType.ToString() + "<br>");
                // strMsg.Append("客户端文件地址：" + postedFile.FileName + "<br>");
                strMsg.Append("上传文件的文件名：" + fileName + "<br>");
 
                // strMsg.Append("上传文件的扩展名：" + fileExtension + "<br><hr>");
                /**////'可根据扩展名字的不同保存到不同的文件夹
                ///注意：可能要修改你的文件夹的匿名写入权限。
                postedFile.SaveAs(System.Web.HttpContext.Current.Request.MapPath("images/") + fileName);
              
                ExcelCheck ec = new ExcelCheck();
                ErrorReport er = new ErrorReport();
                report =  ec.GetExcelFirstTableName(System.Web.HttpContext.Current.Request.MapPath("images/") + fileName, null);
                report.data = "[" + fileName + "]<br>\n" + report.data;

                if (report.reason.Contains("格式错误！"))
                {
                    report.reason = report.reason.Replace("格式错误！", "");
                    report.reason += "格式错误！";
                }
                if (report.reason.Contains("数据库异常！"))
                {
                    report.reason = report.reason.Replace("数据库异常！", "");
                    report.reason += "数据库异常！";
                }
                if (report != null)
                {
                    if (report.reason != "" && report.reason != null)
                    {
                        report.user_id = this.Session["user_id"].ToString();
                        this.Session["ErrorReport"] = report;
                        windowOpen = "<script language=javascript>window.open('ErrorReport.aspx?id=" + ViewState["id"] + "','','height=400, width=600,top=100,left=100,toolbar =no, menubar=no, scrollbars=yes, resizable=no, location=no, status=no'); </script>";
                    }
                    else
                    {
                            ExcelSql ex = new ExcelSql();
                            er = ex.GetExcelFirstTableName(System.Web.HttpContext.Current.Request.MapPath("images/") + fileName, null);
                                               
                    }
                }
               
                if (er==null)
                {
                    message = "[" + fileName + "]<br>" + "上传成功！";
                }
                else
                {
                    message = "[" + fileName + "]" + er.reason;
                  
                    //strMsg.Append("上传文件失败！<hr>");

                  }
                x = iFile;
            }
           
        }
             }
        x += 1;
        strMsg.Append("一共选择了" + x + "个文件上传！<br><hr>");
        strMsg.Append(message + "<br>");
        strStatus.Text = strMsg.ToString();
        return true;
      }
      catch(System.Exception Ex)
      {
        strStatus.Text = Ex.Message;
        return false;
      }

导出
public void DownloadExcle(string name)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + name + ".xls");
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        this.GridView1.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
    }