Exporting Gridview Data to Excel Sheet in asp.net

Question

1.00/5 (1 vote)

See more:

Hi All,

I have used the following code for exporting the gridiew data to Excel. But there is a small problem, while exporting the controls are also visible. Can any one please suggest how to disable the controls in the excel sheet after export of data

C#

protected void btnGetData_Click(object sender, EventArgs e)
    {
        try
        {
            GetDataDisplay();
            btnExportExcel.Enabled = true;
        }
        catch(Exception ex)
        {
            throw ex;
        }
        
    }

    protected void GetDataDisplay()
    {
        int sID = Convert.ToInt32(ddlSurvey.SelectedValue.ToString());
        int pcID=0;
        if (ddlSurvey.SelectedItem.Text.ToLower().EndsWith("l1"))
        {
            if (Convert.ToInt32(ddlPC.SelectedIndex) == 0)
            {
                pcID = 0;
                GetSurveyDetails(sID, pcID);
                gvReport.Visible = true;
                tblAvg.Visible = false;
                if (Session["organisationAverage"].ToString() != string.Empty)
                {
                    tblAvg.Visible = true;
                    lblPCAvg.Visible = true;
                    lblOrgAvg.Visible = true;
                    lblorgAvgScore.Visible = true;
                    lblorgAvgScore.Text = Session["organisationAverage"].ToString();
                }
            }
            else
            {
                pcID = Convert.ToInt32(ddlPC.SelectedValue.ToString());
                GetSurveyDetails(sID, pcID);
                gvReport.Visible = true;
                tblAvg.Visible = false;
            }
            ddlPC.Enabled = true;
            
        }
        else
        {
            ddlPC.Enabled = false;
        }
        

    }


  protected void btnExportExcel_Click(object sender, EventArgs e)
    {

        try
        {
            btnExportExcel.Enabled = false;
            ExportToExcel(ExportExcel, ddlPC.SelectedItem.Text.ToString());
            //ExportExcel.Visible = true;
        }
        catch(Exception ex)
        {
            throw ex;
        }
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        return;
    }

    private void ExportToExcel(HtmlGenericControl ExportExcel, string strFileName)
    {
        
            //ExportExcel.Visible = true;
            GetDataDisplay();
            Response.ClearContent();
            Response.AddHeader("content-disposition", "attachment; filename=" + strFileName + ".xls");
            Response.ContentType = "application/excel";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            ExportExcel.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();
    }

Posted 10-Apr-12 21:21pm

apr1234

Updated 10-Apr-12 21:23pm

uspatel

v3

Add a Solution

Comments

uspatel 11-Apr-12 3:26am

what controls you have used?

apr1234 11-Apr-12 5:33am

button

3 solutions

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)

uspatel · Accepted Answer · 2012-04-10T21:24:00

You can use this custom control to export gridview to excel.
hide that column that have button
add this code on export button click event that you have used

C#

GridView1.DataBind();
if (GridView1.Columns.Count > 0)
    GridView1.Columns[0].Visible = false;//first column hide
else
{
    GridView1.HeaderRow.Cells[0].Visible = false;
    foreach (GridViewRow gvr in GridView1.Rows)
    {
        gvr.Cells[0].Visible = false;
    }
}

Nilesh Patil Kolhapur · Accepted Answer · 2012-04-10T21:29:00

Hi,
For Exporting grid view to excel file use following code

C#

Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition","attachment;filename=g.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter ht = new HtmlTextWriter(sw);
gvDisplay.AllowPaging = false;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End()

and just add following metod in aspx.cs page

C#

public override void VerifyRenderingInServerForm(Control control)
    {

    }

Best Luck
happy Coding

apr1234 · Accepted Answer · 2012-04-11T23:50:00

Solution 3

We can add two functions.
one for displaying the controls: this can be used before export excel
and other for hiding the controls: this can be used after export excel

Posted 11-Apr-12 23:50pm

apr1234

Exporting Gridview Data to Excel Sheet in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0