导出excel文件

最新推荐文章于 2025-08-14 15:22:45 发布

原创最新推荐文章于 2025-08-14 15:22:45 发布 · 104 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Excel #J# #Web

本文介绍了一种使用 C# 编程语言从数据库导出银行账户明细到 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();
}