private void HtmlResponseToExecl()
{
//将数据(html)导入到Excel中
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
string filename = "../Execl/test";
//解决乱码问题
filename = HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8);
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Write("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");
Response.Write("<body>");
Response.Write("<table border=1px>");
//导入Excel表头信息
Response.Write("<tr style='background-color: gray;'><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr>");
Response.Write("<tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr>");
Response.Write("<tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr>");
Response.Write("<tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr>");
Response.Write("<tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr>");
Response.Write("</table>");
Response.Write("</body></html>");
Response.Flush();
Response.End();
}01
2015
12
通过http输出流的方式从将html写入到Excel
发布:叁仟裹世界 | 分类:C# | 评论:0 | 浏览:
相关文章:
asp.net 页面清除缓存 (2015-11-26 15:14:29)
.net自带wsdl.exe的用法与参数说明 (2015-11-20 11:51:28)
发表评论:
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。