导出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();
                        }