把GridView中选中的行导出为Excel文件
来源:互联网 发布:php 依赖注入 编辑:程序博客网 时间:2024/05/21 11:29
01 DataTable dt = new DataTable();02 dt.Columns.Add("empid");03 dt.Columns.Add("empname");04 foreach (GridViewRow row in GridView1.Rows)05 {06 CheckBox chk = (CheckBox)row.FindControl("CheckBox1");07 if (chk.Checked == true)08 {09 int i = row.RowIndex;10 Label lbl = (Label)GridView1.Rows[i].FindControl("Label1");11 Label lbl1 = (Label)GridView1.Rows[i].FindControl("Label2");12 DataRow dr = dt.NewRow();13 dr["empid"] = Convert.ToString(lbl.Text);14 dr["empname"] = Convert.ToString(lbl1.Text);15 dt.Rows.Add(dr);16 }17 }18 GridView GridView1= new GridView()19 GridView1.DataSource = dt;20 GridView1.DataBind();21 Response.Clear();22 Response.Buffer = true;23 Response.ContentType = "application/ms-excel";24 Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", "selectedrows"));25 Response.Charset = "";26 System.IO.StringWriter stringwriter = new StringWriter();27 HtmlTextWriter htmlwriter = new HtmlTextWriter(stringwriter);28 gd.RenderControl(htmlwriter);29 Response.Write(stringwriter.ToString());30 Response.End();