导出数据到EXCEL

public static string ExportTable(DataTable dt)
    {
        StringBuilder data = new StringBuilder();
        data.Append( "<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
        string[] title = new string[] {"标题1","标题2","标题3","标题4"..............};
        //添加标题
        data.Append("<tr style=\"font-weight: bold; white-space: nowrap;\">");
        for (int i = 0; i < title.Length; i++)
        {
            data.Append("<td>" + title[i] + "</td>");
        }
        data.Append("</tr>");

        int n = 1;
        //添加数据
        for (int i = 0; i < dt.Rows.Count; i++)
        {            
            data.Append("<tr style=\"font-weight: bold; white-space: nowrap;\">");
            data.Append("<td style=\"vnd.ms-excel.numberformat:@\">" + n++ + "</td>");
            for (int j = 0; j <dt.Columns.Count; j++)
            {
                data.Append("<td style=\"vnd.ms-excel.numberformat:@\">" + dt.Rows[i][j].ToString() + "</td>");
            }
            data.Append("</tr>");
        }
           
       
        data.Append("</table>");
        return data.ToString();
    }