2015将数据导出到汇总.docVIP

C# 将数据导出到Execl汇总1、将整个html全部输出execl此法将html中所有的内容，如按钮，表格，图片等全部输出到Execl中。 ???Response.Clear();???? ???Response.Buffer=?? true;???? ???Response.AppendHeader(Content-Disposition,attachment;filename=+DateTime.Now.ToString(yyyyMMdd)+.xls);?????????? ???Response.ContentEncoding=System.Text.Encoding.UTF8;?? ???Response.ContentType?? =?? application/vnd.ms-excel;?? ???this.EnableViewState?? =?? false;?? 利用了ContentType属性，它默认的属性为text/html，这时将输出为超文本，即我们常见的网页格式到客户端，如果改为ms-excel将将输出excel格式，也就是说以电子表格的格式输出到客户端，这时浏览器将提示你下载保存。ContentType的属性还包括：image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword我们也可以输出(导出)图片、word文档等。下面的方法，也均用了这个属性。2、将DataGrid控件中的数据导出ExeclSystem.Web.UI.Control ctl=this.DataGrid1;//DataGrid1是你在窗体中拖放的控件HttpContext.Current.Response.AppendHeader(Content-Disposition,attachment;filename=Excel.xls); HttpContext.Current.Response.Charset =UTF-8;???? HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default; HttpContext.Current.Response.ContentType =application/ms-excel;ctl.Page.EnableViewState =false;??? System.IO.StringWriter? tw = new System.IO.StringWriter() ; System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter (tw); ctl.RenderControl(hw); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); 如果你的DataGrid用了分页，它导出的是当前页的信息，也就是它导出的是DataGrid中显示的信息。而不是你select语句的全部信息。 为方便使用,写成方法如下：public void DGToExcel(System.Web.UI.Control ctl)?? ? { ?? HttpContext.Current.Response.AppendHeader(Content-Disposition,attachment;filename=Excel.xls); ?? HttpContext.Current.Response.Charset =UTF-8;???? ?? HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default; ?? HttpContext.Current.Response.ContentType =application/ms-excel;?? ctl.Page.EnableViewState =false;??? ?? System.IO.StringWriter? tw = new System.IO.StringWriter() ; ?? System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter (tw); ?? ctl.RenderControl(hw); ?? HttpContext.Current.Response.Write(tw.ToString()); ?? HttpCont