DataTable导出Execl代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 DataTable导出Execl

作者:dezai / 发布于2014/5/26/ 624

DataTable导出Execl


	protected void btnPrint_Click(object sender, EventArgs e)
	 {
	 string strPath = "MFOut" + DateTime.Now.ToString("yyyymmddhhmmssfff") + ".xls";
	 DataGrid dg = new DataGrid();
	 dg.DataSource = dtMain;
	 dg.DataBind();
	 Response.Clear();
	 Response.AddHeader("content-disposition", "attachment;filename=" + strPath + "");
	 Response.Charset = "gb2312";
	 Response.ContentEncoding = System.Text.Encoding.UTF8;//不设置会有乱码
	 Response.ContentType = "application/vnd.xls";
	 System.IO.StringWriter stringWrite = new System.IO.StringWriter();
	 System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
	 dg.RenderControl(htmlWrite);
	 Response.Write(stringWrite.ToString());
	 Response.End();
	 }
	 public override void VerifyRenderingInServerForm(Control control)
	 {
	 //这个方法不能删除掉 导出时要用到，不然会报错：
	 //类型&ldquo;GridView&rdquo;的控件&ldquo;ctl00_ContentPlaceHolder1_GridView1&rdquo;必须放在具有 runat=server 的窗体标记内
	 }

试试其它关键字

　导出Execl　

同语言下

可能有用的

dezai贡献的其它代码(1065)