将datagrid中显示的内容导入到Excel中

来源：互联网发布：用js改变display 编辑：程序博客网时间：2024/05/01 23:57

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[6].Visible = false; //第几列不导入到excel中
 DataGrid1.Columns[5].Visible = false;
 DataGrid1.RenderControl(htwHtmlTextWriter);
 Response.Write (swStringWriter.ToString());
 Response.End();
 }
 //去除其它格式
 private void ResetDataGrid(DataGrid grid)
 {
 int i;
 int intItemCount;
 HyperLink lnkPlanName;

intItemCount = grid.Items.Count;

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

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