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();
}
C#生成Word文档
最新推荐文章于 2024-08-23 22:33:11 发布