GridView数据以字符串形式导入Excel

来源：互联网发布：类似向日葵的软件编辑：程序博客网时间：2024/04/19 11:19

protected void Button1_Click( object sender, System.EventArgs e )
...{
    Response.Clear();
    Response.Buffer = true;
    Response.Charset = "GB2312";
    Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
    // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
    Response.ContentEncoding = System.Text.Encoding.UTF7;
    Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
    this.GridView1.RenderControl(oHtmlTextWriter);
    Response.Output.Write(oStringWriter.ToString());
    Response.Flush();
    Response.End();

}
public override void VerifyRenderingInServerForm( Control control )
{

   }
protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e )
...{
            i f (e.Row.RowType == DataControlRowType.DataRow)
    ...    {
              e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
            }

}