Grid数据导出到Excel

最新推荐文章于 2024-06-07 01:11:49 发布

xuyabao

最新推荐文章于 2024-06-07 01:11:49 发布

阅读量420

点赞数

分类专栏： Web开发 .NET 文章标签： datagrid hyperlink excel string null c

本文链接：https://blog.csdn.net/xuyabao/article/details/2172283

版权

Web开发同时被 2 个专栏收录

24 篇文章 0 订阅

订阅专栏

.NET

12 篇文章 0 订阅

订阅专栏

//Grid数据导出到Excel

private void ExportToExcel()
{
string strFileName;

strFileName = HttpUtility.UrlEncode("导出名称.xls");

   Response.Clear();  //清空
   Response.Buffer = true;  //缓冲输出
   Response.Charset = "GB2312";

   Response.AppendHeader("Content-Disposition","attachment;filename=" + strFileName);
   Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
   Response.ContentType = "application/ms-excel";
   this.EnableViewState = false;
   //定义一个输入流
   System.IO.StringWriter swStringWriter = new System.IO.StringWriter();
   System.Web.UI.HtmlTextWriter htwHtmlTextWriter = new System.Web.UI.HtmlTextWriter(swStringWriter);

ResetDataGrid(DataGrid1);//去除其它格式

Response.Write ("导出名称");
 DataGrid1.Columns[13].Visible = false;
 DataGrid1.RenderControl(htwHtmlTextWriter);
 Response.Write (swStringWriter.ToString());
 Response.End();
 }

//去除其它格式
  private void ResetDataGrid(C1WebGrid grid)
  {
   int i;
   int intItemCount;
//   string strPlanName;
   HyperLink lnkPlanName;

intItemCount = grid.Items.Count;

for (i = 0; i < intItemCount; i++)
 {
 lnkPlanName = (HyperLink)grid.Items[i].Cells[6].FindControl("lnkPlanName");

    if (lnkPlanName != null)
    {
     lnkPlanName.NavigateUrl = "";

//     strPlanName = grid.Items[i].Cells[5].Text;
//
//     strPlanName = lnkPlanName.Text;
//
//     grid.Items[i].Cells[5].Controls.Clear();
//
//     grid.Items[i].Cells[5].Text = strPlanName;
    }
   }
  }