当前位置： 移动技术网 > IT编程>开发语言>.net > HTML转EXCEL的方法

HTML转EXCEL的方法

2019年01月07日  | 移动技术网IT编程  | 我要评论

杭州拱墅区教育局,美女自缚,小泽玛利亚 电影

 1         private void toexcel(string html)
 2         {
 3 
 4             response.contenttype = "application/force-download";
 5             response.addheader("content-disposition",
 6                 "attachment; filename=" + datetime.now.tostring("yyyymmddhhmmss") + ".xls");
 7             response.write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
 8             response.write("<head>");
 9             response.write("<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">");
10             string filecss = server.mappath("~/ui/themes/drp.ui.ext.css");
11             string csstext = string.empty;
12             streamreader sr = new streamreader(filecss);
13             var line = string.empty;
14             while ((line = sr.readline()) != null)
15             {
16                 csstext += line;
17             }
18             sr.close();
19             response.write("<style>" + csstext + "</style>");
20             response.write("<!--[if gte mso 9]><xml>");
21             response.write("<x:excelworkbook>");
22             response.write("<x:excelworksheets>");
23             response.write("<x:excelworksheet>");
24             response.write("<x:name>report data</x:name>");
25             response.write("<x:worksheetoptions>");
26             response.write("<x:print>");
27             response.write("<x:validprinterinfo/>");
28             response.write("</x:print>");
29             response.write("</x:worksheetoptions>");
30             response.write("</x:excelworksheet>");
31             response.write("</x:excelworksheets>");
32             response.write("</x:excelworkbook>");
33             response.write("</xml>");
34             response.write("<![endif]--> ");
35             response.write(html);//html
36             response.flush();
37             response.end();
38         }

 

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网