将Gridview数据导出到excel

最新推荐文章于 2024-08-22 19:11:57 发布

anzhan6919

最新推荐文章于 2024-08-22 19:11:57 发布

阅读量163

点赞数

原文链接：http://www.cnblogs.com/lq0418/p/9592875.html

版权

   public void ExportData(GridView obj)
    {

        try
        {
            obj.AllowSorting = false;
            string style = "";
            if (obj.Rows.Count > 0)
            {
                style = @"<style> .text { mso-number-format:\@; } </script> ";
            }
            else
            {
                style = "no data.";
            }
            HttpContext.Current.Response.ClearContent();
            DateTime dt = DateTime.Now;
            string filename = dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xls");
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            obj.RenderControl(htw);

            HttpContext.Current.Response.Write(style);
            HttpContext.Current.Response.Write(sw.ToString());

            HttpContext.Current.Response.End();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

转载于:https://www.cnblogs.com/lq0418/p/9592875.html