导出excel文件

dts.OutPortBankTransaction(tmpDTSObjectID, out Result, out _OMLW);
DataTable dtResult = Result.Tables[0];

StringWriter sw = new StringWriter();
sw.WriteLine("<table cellspacing=\"0\" border=\"1\" id=\"DataGrid\" style=\"border-collapse:collapse;\">");

StringBuilder sbResult = new StringBuilder();
//列头
sbResult.Append("<tr>");
for (int i = 0; i < dtResult.Columns.Count; i++)
{
sbResult.AppendFormat(String.Format("<td>{0}</td>", dtResult.Columns[i].Caption));
}
sbResult.Append("</tr>");
sw.WriteLine(sbResult.ToString());

if (dtResult.Rows.Count > 0)
{
for (int i = 0; i < dtResult.Rows.Count; i++)
{
sbResult.Remove(0, sbResult.Length);

sbResult.Append("<tr>");
for (int j = 0; j < dtResult.Columns.Count; j++)
{

sbResult.AppendFormat("<td style=\"vnd.ms-excel.numberformat:@\">{0}</td>", dtResult.Rows[i][j].ToString());
}
sbResult.Append("</tr>");
sw.WriteLine(sbResult.ToString());
}

sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode("银行账户明细" + DateTime.Now.ToString("yyyyMMddhhmmssffff"), System.Text.Encoding.UTF8) + ".xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}