C#生成Word文档

最新推荐文章于 2024-09-19 11:46:51 发布

原创最新推荐文章于 2024-09-19 11:46:51 发布 · 446 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c# #session #文档

.Net 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了两种从ASP.NET应用程序中导出数据到Excel文件的方法。第一种方法使用GridView控件直接渲染为HTML表格并发送到客户端；第二种方法通过DataTable生成纯文本格式的内容，并设置响应头以实现文件下载。

GridView 方法一:
protected void btnOut_Click(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dgvItem.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{

}

DataTable 方法二:
protected void btnOut_Click(object sender, EventArgs e)
{
int i = 1;
DataTable dt = (DataTable)Session["pageDataTable"];
StringWriter sw = new StringWriter();
sw.WriteLine("序号/t订单号/t买家/t卖家/t付款金额/t付款日期");
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(i + "/t" + dr["orderNo"] + "/t" + dr["orderuser"] + "/t" + dr["offeruser"] + "/t" + dr["transAmt"] + "/t" + dr["transDate"]);
i++;
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();

}