Html标签输出到前台并导出到Excel

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

StringBuilder
html = new StringBuilder();

        html.Append("<table
cellpadding=\"0\" cellspacing=\"0\" style=\"border:1px solid black;text-align:center;\" width=\"700\">\n");

        html.Append("<tr>\n<td
style=\"border-bottom: 1px solid black;text-align:center;\" colspan=\"6\">XXXX年XX月课程表</td>\n</tr>\n");

        /*********************************************/

        html.Append("<tr>\n");

        for (int i
= 0; i <= 5; i++)

        {

            if (i
== 5)

            {

                html.Append("<td
style=\"border-bottom: 1px solid black;text-align: center;\">" +
(string.IsNullOrEmpty(toCNNum(i))
? "&nbsp;" :
toCNNum(i)) + "</td>\n");

            }

            else

            {

                html.Append("<td
style=\"border-bottom: 1px solid black;text-align:center;border-right: 1px solid black;\">" +
(string.IsNullOrEmpty(toCNNum(i))
? "&nbsp;" :
toCNNum(i)) + "</td>\n");

            }

        }

        html.Append("</tr>\n");

        /*********************************************/

        html.Append("<tr>\n");

2

3

4

5

6

7

8

9

10

11

12

13

//输出的应用类型

        Response.ContentType
= "application/vnd.ms-excel";

        //设定编码方式，若输出的excel有乱码，可优先从编码方面解决

        //
Response.Charset = "gb2312";

        Response.Charset
= "utf-8";

        Response.ContentEncoding
= System.Text.Encoding.UTF8;

        //关闭ViewState，此属性在Page中

        EnableViewState
= false;

        //filenames是自定义的文件名

        Response.AppendHeader("Content-Disposition",
"attachment;filename=data.xls");

        //content是步骤1的html，注意是string类型

        Response.Write(createTable());

       Response.End();