Export only gridview data to excel format in ASP.NET C#

Question

0.00/5 (No votes)

See more:

In my page I have two textbox controls, where I am gating the date from the Calendar Extender & in the export to excel Button I am going to export the Gridview data to excel sheet. When I am gating the excel sheet its show the the textbox & button also from which i am export the excel Sheet.

I have written the export code in the Export Button. Like:-

C#

protected void Export_to_Excel_Click(object sender, EventArgs e)
    {
        try
        {

            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
            Response.ContentType = "application/ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            Grd_MidData.AllowPaging = false;
            bindgriddata();
            //Change the Header Row back to white color
            Grd_MidData.HeaderRow.Style.Add("background-color", "#FFFFFF");
            //Applying stlye to gridview header cells
            for (int i = 0; i < Grd_MidData.HeaderRow.Cells.Count; i++)
            {
                Grd_MidData.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");
            }
            Grd_MidData.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.Flush();
        }
        catch (Exception ee)
        {

        }
    }

When I am gating the excel sheet it shows the gridview data along with the two text box & the button from where I am doing the filtering.

So any one suggest me, How to show only the gridview data but not show the Textbox & button on the excel sheet.

What I have tried:

Here the gridview data is showing along with the From date: To Date: textbox & the button also. So how can i remove these field from the Excel sheet.

Posted 9-May-16 1:21am

Sabyasachi Mishra

Updated 9-May-16 1:55am

Santosh Kokatnur

v2

Add a Solution

Comments

Karthik_Mahalingam 9-May-16 7:38am

post the markup code..

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)

Karthik_Mahalingam · Answer 1 · 2016-05-09T01:55:00

try this

C#

protected void Export_to_Excel_Click(object sender, EventArgs e)
        {

            try
            {
                GridView gv = new GridView();
                Grd_MidData.AllowPaging = false;
                BindCustomersDDL(); 
                gv = Grd_MidData;  // cloning the existing grid, so that it will not disturb the existing grid

                Response.ClearContent();
                Response.Buffer = true;
                Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
                Response.ContentType = "application/ms-excel";
                StringWriter sw = new StringWriter();
                HtmlTextWriter htw = new HtmlTextWriter(sw);

                for (int i = 0; i < Grd_MidData.HeaderRow.Cells.Count; i++)
                    gv.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");


                // Hiding the unwanted columns in the excel output 
                int[] columnsToBeHidden = { 2,8 }; // zero based index, this will hide 3rd ad 9th column 
                for (int i = 0; i < columnsToBeHidden.Length; i++)
                    gv.Columns[i].Visible = false;



                gv.RenderControl(htw);
                Response.Write(sw.ToString());
                Response.Flush();
            }
            catch (Exception ee)
            {

            }
        }

Pass the index of the column which you want to hide

C#

int[] columnsToBeHidden = { 5,6};