asp.net 选取GridView某几行导出到Excel

asp.net前台

 <asp:Button ID="search" runat="server" Text="导出" OnClick="export_Click"></asp:Button>
 <asp:GridView ID="GridView" runat="server" AutoGenerateColumns="false" Height="100%" Width="100%" CssClass="gridview">
   <Columns>
 <asp:TemplateField>
   <HeaderTemplate>
   <asp:CheckBox ID="cbSelAll" runat="server" OnCheckedChanged ="cbSelAll_CheckedChanged" AutoPostBack="True" />
  </HeaderTemplate>
   <ItemStyle HorizontalAlign="Center" />
   <ItemTemplate>
 <asp:CheckBox ID="cbSel" runat="server" />
    </ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="序号" InsertVisible="False">
 <ItemStyle HorizontalAlign="Center" />
<HeaderStyle HorizontalAlign="Center" />
<ItemTemplate>
<%--此处序号取值需结合自身情况--%>
   <asp:Label ID="id" runat="server" Text='<%# this.GridView.PageIndex * this.GridView.PageSize + this.GridView.Rows.Count + 1%>' Visible="True" />
</ItemTemplate>
 </asp:TemplateField>
  <asp:TemplateField HeaderText="列名1">
      <ControlStyle Width="100%" />
      <ItemTemplate>
          <asp:Label Style="border: 0px; text-align: center" ID="stock" runat="server" Text='<%#Eval("stock") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="列名2">
<ControlStyle Width="100%" />
<ItemTemplate>
<asp:Label Style="border: 0px; text-align: center" ID="serialNumber" runat="server" Text='<%#Eval("serialNumber") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle CssClass="CurrentRow" />
<AlternatingRowStyle CssClass="AlternatingRow" />
</asp:GridView>

asp.net 后台

 //导出事件
protected void export_Click(object sender, EventArgs e)
{
//定义dataTable，将GridView转换为dataTable导出到Excel
   DataTable dt = new DataTable();
   DataColumn dc;//创建列
   DataRow dr;  //创建行 

   //构造列(去除CheckBox第一列)
   for (int i = 1; i < GridView.Columns.Count; i++)
   {
       dc = new DataColumn();
       dc.ColumnName = GridView.Columns[i].HeaderText;
       dt.Columns.Add(dc);
   }

   // 构造列
   for (int j = 0; j < GridView.Rows.Count; j++)
   {
       //定义第一列
       CheckBox checkBox = (CheckBox)GridView.Rows[j].Cells[0].FindControl("cbSel");
       dr = dt.NewRow();
       if (checkBox.Checked)
       {
           //若被选中，就添加新行

           //for (int k = 0; k < GridView.Columns.Count; k++)
           //{
           //    //循环取值，奈何取到都是"",只好写成dr[0]、dr[1]、dr[2]
           //    dr[k] = GridView.Rows[j].Cells[k].Text;
           //}
           
           //序号列取值
           dr[0] = dt.Rows.Count+1;
           Label stock = (Label)GridView.Rows[j].Cells[1].FindControl("stock");
           dr[1] = stock.Text.ToString();
           Label serialNumber = (Label)GridView.Rows[j].Cells[1].FindControl("serialNumber");
           dr[2] = serialNumber.Text.ToString();
           dt.Rows.Add(dr);
       }
   }
    if (dt.Rows.Count > 0)
   {
       //用户勾选数据后进行导出
       ExcelUtil.ExportExcelFile(System.Web.HttpContext.Current.Response, "自定义Excel名称" + DateTime.Now.ToString("yyyyMMddHHmmss"), dt);
   }
}
        
//ExcelUtil类中的方法
 public static void ExportExcelFile(HttpResponse Response, string strExcelFileName, DataTable table)
{
   string fileFullName = ExportExcel(table, strExcelFileName);

   try
   {
       string fileName = HttpUtility.UrlEncode(strExcelFileName + ".xlsx", Encoding.UTF8);
       FileInfo fileInfo = new FileInfo(fileFullName);
       Response.Clear();
       Response.ClearContent();
       Response.ClearHeaders();
       Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
       Response.AddHeader("Content-Length", fileInfo.Length.ToString());
       Response.AddHeader("Content-Transfer-Encoding", "binary");
       Response.ContentType = "application/octet-stream";
       Response.ContentEncoding = System.Text.Encoding.UTF8;
       Response.WriteFile(fileInfo.FullName);
       Response.Flush();
   }
   catch (Exception ex)
   {
       if (!(ex is ThreadAbortException))
       {
           throw ex;
       }
   }
   finally
   {
       File.Delete(fileFullName);
   }

}