Selected columns in gridview

Question

0.00/5 (No votes)

See more:

HI ,

is there any solution to export selected columns of grid view in excel ,
as i found many blogs and solution about the selected rows but not about columns ,
pls guys let me know for any solution for it .

thanks in advance .

Posted 16-Sep-15 5:40am

amitkumar5734

Updated 16-Sep-15 5:58am

F-ES Sitecore

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas_Kumar · Answer 1 · 2015-09-16T08:33:00

Solution 1

Suppose you have grid with ID GridView1 and it contains two columns. And you want to export only first column then find below code:

C#

private void btnExportExcel_Click()
{
    Response.Clear();
    Response.Buffer = true;
  
    Response.AddHeader("content-disposition",
     "attachment;filename=MyData.xls");
    Response.Charset = "";
    Response.ContentType = "application/vnd.ms-excel";
    StringWriter sw = new StringWriter();
    HtmlTextWriter hw = new HtmlTextWriter(sw);
 
    GridView1.AllowPaging = false;
    GridView1.DataBind();
 
    GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
    GridView1.HeaderRow.Cells[0].Style.Add("background-color", "green");
    GridView1.HeaderRow.Cells[1].Style.Add("background-color", "green");
	
    GridView1.HeaderRow.Cells[0].Visible = True;
    GridView1.HeaderRow.Cells[1].Visible = False;
 
    for (int i = 0; i < GridView1.Rows.Count;i++ )
    {
        GridViewRow row = GridView1.Rows[i];
        row.Cells[0].Visible = True;
        row.Cells[1].Visible = False;
        row.BackColor = System.Drawing.Color.White;
        row.Attributes.Add("class", "textmode");
    }

    GridView1.RenderControl(hw);
    string style = @"<style> .textmode { mso-number-format:\@; } </style>";
    Response.Write(style);
    Response.Output.Write(sw.ToString());
    Response.End();
}

Here I have hard coded(True/False) and if you need it dynamic then you ad checkboxes to side of the column and onchange of checkbox store it in viewstate. Later you can fetch checked columns from view state.

http://www.aspsnippets.com/Articles/ASP.Net-GridView-Export-only-selected-columns-to-Excel-Sheet.aspx[^]

Posted 16-Sep-15 8:33am

Manas_Kumar

Updated 16-Sep-15 8:48am

v3

Comments

amitkumar5734 17-Sep-15 10:30am

not working i have tried this one , any other method to select the columns and export .

[no name] 17-Sep-15 10:36am

Which line you are getting error and what exception you are getting.

amitkumar5734 17-Sep-15 10:55am

actually in my project i have a calendar control and on Calendar1_SelectionChanged event , i am binding my grid view , so on page load when i am trying to call if (IsPostBack) { GetCheckBoxStates();} , throws error "object reference not set to an instance of an object "

here i got error ,

private void GetCheckBoxStates()
{
CheckBox chkCol1 = (CheckBox)gd1.HeaderRow.Cells[0].FindControl("chkCol1");
CheckBox chkCol2 = (CheckBox)gd1.HeaderRow.Cells[0].FindControl("chkCol2");

and i know why this is happing but getting null value but i am not able to solve this where i need to call this function because on selection event my grid view is binding and not able to call my grid view on page load .

amitkumar5734 17-Sep-15 11:10am

hi any answer .

[no name] 17-Sep-15 11:19am

Did you add checkbox control in HeaderTemplate of Grideview. Please follow the link properly I provided in my answer it will resolve your problem.

amitkumar5734 17-Sep-15 11:27am

yes i have added header
<asp:GridView ID="gd1" runat="server" style="margin-left:0px;" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" GridLines="None" CellSpacing="1" AutoGenerateColumns="false" OnRowDataBound="gd1_RowDataBound" OnRowCommand="gd1_RowCommand">
<columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkCol1" runat="server" Checked ="true" />
<asp:Label ID="lblCol1" runat="server" Text ="MarketingRequest"/>
</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lbl_mr" runat="server" Text='<%#Eval("MarketingRequest") %>'>

<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkCol2" runat="server" Checked="true" />
<asp:Label ID="lblCol2" runat="server" Text ="ServiceOrder"/>
</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lbl_so" runat="server" Text='<%#Eval("ServiceOrder") %>'>

<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkCol3" runat="server" Checked ="true" />
<asp:Label ID="lblCol3" runat="server" Text = "TicketID"/>
</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lbl_ticketid" runat="server" Text='<%#Eval("TicketID") %>'>

<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkCol4" runat="server" Checked = "true" />
<asp:Label ID="lblCol4" runat="server" Text = "TicketDueDate"/>
</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lbl_duedate" runat="server" Text='<%#Eval("TicketDueDate") %>'>

<asp:TemplateField >
<HeaderTemplate>
<asp:CheckBox ID="chkCol5" runat="server" Checked = "true" />
<asp:Label ID="lblCol5" runat="server" Text = "ServiceName"/>
</HeaderTemplate>
<itemtemplate>
<asp:Label ID="lbl_sn" runat="server" Text='<%#Eval("ServiceName") %>'>

see .