1/1页1 跳转到查看:388
发新话题 回复该主题

在asp.net中(C#,BS),将dataGrid导出到Execl

在asp.net中(C#,BS),将dataGrid导出到Execl

public void ExportToExcel(System.Web.UI.Control ctl)
    {
        string fileName = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
        bool CurrCtlVisible = ctl.Visible;
        ctl.Visible = true;
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.C;
        ctl.Page.EnableViewState = false;
        System.IO.StringWriter tw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw);
        ctl.RenderControl(hw);
        Response.Write("<meta  http-equiv=Content-Type  content=text/html;charset=gb2312>");
        Response.Write(tw.ToString());
        Response.End();
        ctl.Page.EnableViewState = true;
        ctl.Visible = CurrCtlVisible;
    }

TOP

 

好东西,收了

TOP

 

基础的东西要好好掌握咯。
追逐的永恒。。。。

TOP

 
1/1页1 跳转到
发表新主题 回复该主题