ultrawebgrid导出excel

其实导出EXCEL的方法有很多，这里使用的是system.io

代码如下:

 

protected void btn_toExcel_Click(object sender, EventArgs e)
{
        string thedate = DateTime.Now.ToString();
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "Big5"; //字体设置
     　　Response.AppendHeader("Content-Disposition", "attachment;filename=Report.xls");
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType = "application/ms-excel";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
        oHtmlTextWriter.WriteLine("報表，導出時間:" + thedate + "");
        oHtmlTextWriter.WriteLine("<table cellspacing=\"0\", rules=\"all\", border=\"3\">");
        UltraWebGrid1.RenderControl(oHtmlTextWriter);
        oHtmlTextWriter.WriteLine("</table>");
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
}
 
 

 

 这里特别要注意，一定要加一段下面的代码，否则执行就会报错

 

    public override void VerifyRenderingInServerForm(Control control)
    { }

 

这样导出可以把设置的格式（例如颜色）导出来,也有一个弊端，会把隐藏列也导出来。