Problem of exporting gridview data to excel

Question

0.00/5 (No votes)

See more:

I am trying to export gridview data to excel but when i open that excel sheet,it shows nothing. I am using the following code

C#

protected void btnExport_Click(object sender, EventArgs e)
       {
           Response.ClearContent();
           Response.Buffer = true;
           Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
           Response.ContentType = "application/ms-excel";
           System.IO.StringWriter sw = new System.IO.StringWriter();
           HtmlTextWriter htw = new HtmlTextWriter(sw);
           gvDetails.AllowPaging = false;
           gvDetails.DataBind();
           //Change the Header Row back to white color
           gvDetails.HeaderRow.Style.Add("background-color", "#FFFFFF");
           //Applying stlye to gridview header cells
           for (int i = 0; i < gvDetails.HeaderRow.Cells.Count; i++)
           {
               gvDetails.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
           }
           int j = 1;
           //This loop is used to apply stlye to cells based on particular row
           foreach (GridViewRow gvrow in gvDetails.Rows)
           {
               if (j <= gvDetails.Rows.Count)
               {
                   if (j % 2 != 0)
                   {
                       for (int k = 0; k < gvrow.Cells.Count; k++)
                       {
                           gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
                       }
                   }
               }
               j++;
           }
           gvDetails.RenderControl(htw);
           Response.Write(sw.ToString());
           Response.End();
       }
   }

I have also applied the verify rendering in server form method and have set the EnableEventValidation to false, but it in the excel sheet i did not get any data.
Please help. All the columns in gridview are Template Fields.

Posted 11-Nov-11 18:12pm

utkarsh3146

Updated 11-Nov-11 19:19pm

Wayne Gaylard

v2

Add a Solution

Comments

Wayne Gaylard 12-Nov-11 1:20am

Put code in code blocks and removed bold (this is considered shouting on internet forums and is rude).

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)

_Tushar Patil · Answer 1 · 2011-11-11T18:44:00

Try Following Code It IS Working For Me...............

C#

public static void ExportToExcel(GridView gv, string filename)
       {
           HttpContext.Current.Response.Clear();
           HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", filename));
           HttpContext.Current.Response.ContentType = "application/ms-excel";

           using (StringWriter sw = new StringWriter())
           {
               using (HtmlTextWriter htw = new HtmlTextWriter(sw))
               {
                   //  Create a table to contain the grid
                   Table table = new Table();

                   //  include the gridline settings
                   table.GridLines = gv.GridLines;

                   //  add the header row to the table
                   if (gv.HeaderRow != null)
                   {
                      PrepareControlForExport(gv.HeaderRow);
                       table.Rows.Add(gv.HeaderRow);
                   }
                   //Make Header Coloruful

                   for (int j = 0; j < gv.Columns.Count; j++)
                   {
                       //Apply style to Individual Cells
                       gv.HeaderRow.Cells[j].Style.Add("background-color", "yellow");
                   }

                   //  add each of the data rows to the table
                   foreach (GridViewRow row in gv.Rows)
                   {
                      PrepareControlForExport(row);
                       table.Rows.Add(row);
                   }

                   //  add the footer row to the table
                   if (gv.FooterRow != null)
                   {
                       PrepareControlForExport(gv.FooterRow);
                       table.Rows.Add(gv.FooterRow);
                   }

                   //  render the table into the htmlwriter
                   table.RenderControl(htw);

                   //  render the htmlwriter into the response
                   HttpContext.Current.Response.Write(sw.ToString());
                   HttpContext.Current.Response.End();
               }
           }


       }

To Export Data From Gridview........
Call Above Function..as

ExportToExcel(grd_data, "abc.xls")