XML格式导出Excel

protected void Btn_Up(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false; Hashtable ht = new Hashtable();
try
{
ht["PayAcc"] = payeeaccno.Value;
ht["BgDate"] = rzbDate.Value.Replace("-", "");
ht["EdDate"] = rzEDate.Value.Replace("-", "");
ht["BizBrid"] = bizBrandid;
}
catch (Exception)
{
throw;
}
WithholdingQueryBll wiBill = new WithholdingQueryBll();//数据操作类
int count = 0;
DataTable qdp = wiBill.QuerDeductPayee(ht, true, out count);//查询数据，返回DataTable
CreateExcel(qdp, "", "xls");
}
public void CreateExcel(System.Data.DataTable dt, String TableTitle, string fileName)
{
//1） 文本：vnd.ms-excel.numberformat:@
//2） 日期：vnd.ms-excel.numberformat:yyyy/mm/dd
//3） 数字：vnd.ms-excel.numberformat:#,##0.00
//4） 货币：vnd.ms-excel.numberformat:￥#,##0.00
//5） 百分比：vnd.ms-excel.numberformat: #0.00%
StringBuilder strb = new StringBuilder();
DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的
strb.Append(" ");
strb.Append("xmlns:x=\"urn:schemas-microsoft-com:office:excel\"");
strb.Append("xmlns=\" strb.Append(\" ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" Sheet1 ");
strb.Append(" ");
strb.Append(" 285 ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" 3 ");
strb.Append(" 1 ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" False ");
strb.Append(" False ");
strb.Append(" False ");
strb.Append(" ");
strb.Append(" ");
strb.Append(" 6750 ");
strb.Append(" 10620 ");
strb.Append(" 480 ");
strb.Append(" 75 ");
strb.Append(" False ");
strb.Append(" False ");
strb.Append(" ");
strb.Append(" ");
strb.Append("");
strb.Append(" ");
//strb.Append("