DataList转Excel
来源:互联网 发布:连化青真实案子知乎 编辑:程序博客网 时间:2024/06/08 15:30
void ExportExcel( System.Web.UI.WebControls.DataList dl, string strFileName)
{
strFileName = System.Web.HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8);
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.Charset = "gb2312";
System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "online; filename=" + strFileName + ".xls");
System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("zh-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dl.RenderControl(oHtmlTextWriter);
System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString().Replace("<td", "<td STYLE='MSO-NUMBER-FORMAT://@'"));
System.Web.HttpContext.Current.Response.Buffer = false;
System.Web.HttpContext.Current.Response.End();
}
- DataList转Excel
- datalist导出excel
- datalist的数据导入到Excel中
- DataList自定义分页(转)
- DATALIST
- datalist
- datalist
- DataList
- DataList
- datalist
- DataList
- datalist
- Datalist
- DataList
- datalist
- datalist
- DataList
- datalist
- Java面试精选3
- (转)字符集之间转换(UTF-8,UNICODE,Gb2312)
- Windows XP下搭建GTK+开发环境
- 构建高性能网站,针对前台工程师--总结篇
- jQuery 选择器
- DataList转Excel
- java集合框架学习—ArrayList的实现原理
- 非阻塞的网络编程
- C++类继承关系问题(遗忘好久,拾起来)
- java中final关键字的使用及static final 和final的区别
- Java中的Class类
- C#发送邮件
- 根据手机类型适配适当页面
- Git服务器Gitosis安装设置