.net excel html,HTML转EXCEL的方法

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("");

8 response.write("

");

9 response.write("");

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("");

20 response.write(" ");

35 response.write(html);//html

36 response.flush();

37 response.end();

38 }