Export to excel not working

Question

0.00/5 (No votes)

See more:

I have a grid view like the following:

XML

<form id="form21">
  <asp:GridView ID="GVcandidates" runat="server" AllowPaging="true" AllowSorting="True" AutoGenerateColumns="False" CssClass="tabLayout_Fixed" OnPageIndexChanging="GVcandidates_PageIndexChanging" OnRowCommand="GVcandidates_RowCommand" OnRowDataBound="GVcandidates_RowDataBound" OnSorting="GVcandidates_Sorting" PageSize="50" Width="100%">
</form>

I modified the page header like:

EnableEventValidation="false"

And onclick of an button I write the following in code behind:

C#

protected void exclexp_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";
   StringWriter sw = new StringWriter();
   HtmlTextWriter htw = new HtmlTextWriter(sw);
   GVcandidates.AllowPaging = false;
   //Change the Header Row back to white color
   GVcandidates.HeaderRow.Style.Add("background-color", "#FFFFFF");
   //Applying stlye to gridview header cells
   for (int i = 0; i < GVcandidates.HeaderRow.Cells.Count; i++)
   {
      GVcandidates.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 GVcandidates.Rows)
   {
      //gvrow.BackColor = Color.White;
      if (j <= GVcandidates.Rows.Count)
      {
         if (j % 2 != 0)
         {
            for (int k = 0; k < gvrow.Cells.Count; k++)
            {
               gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
            }
         }
      }
      j++;
   }
   GVcandidates.RenderControl(htw);
   Response.Write(sw.ToString());
   Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{
   /* Confirms that an HtmlForm control is rendered for the specified ASP.NET server control at run time. */
}

When I click the button nothing is happening, please help I am very new to asp.net

Posted 21-Apr-14 23:14pm

srikanta.mondol

Updated 21-Apr-14 23:21pm

phil.o

v2

Add a Solution

Comments

Honey Jagyasi 22-Apr-14 5:27am

Try to debug the above code first. Always maintain ur code in Try catch block. If you find any error during debugging,Paste here.

srikanta.mondol 22-Apr-14 5:30am

I have done a debugging, but not getting any error, it is executing successfully and landing to the browser, with no result.

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)

Mehdi Gholam · Answer 1 · 2014-04-22T00:25:00

Solution 1

The Excel file format is not HTML, so you either need to use a library for creating true Excel files like http://epplus.codeplex.com/[^] or you should create a html representation of what you want.

Posted 22-Apr-14 0:25am

Mehdi Gholam

Honey Jagyasi · Answer 2 · 2014-04-22T01:39:00

Use this code for export to excel gridview data. Make sure you pass correct datasource to dt(You can provide same datasource which you provide to gridview).

onbuttonclick()
{
datatable dt= new datatable();
dt= obj.getdataforexcel(); // here you can use datasource with which gridview is bind.
ExportToExcel(dt);
}

//export to excel function
  public void ExportToExcel(DataTable dt)
        {
            string XlsPath = "Sheet1";
            string attachment = string.Empty;
            HttpContext context = HttpContext.Current;
            if (XlsPath.IndexOf("\\") != -1)
            {
                string[] strFileName = XlsPath.Split(new char[] { '\\' });
                attachment = "attachment; filename=" + strFileName[strFileName.Length - 1] + ".xls";
            }
            else
                attachment = "attachment; filename=" + XlsPath + ".xls";
            try
            {
                context.Response.ClearContent();
                context.Response.AddHeader("content-disposition", attachment);
                context.Response.ContentType = "application/vnd.ms-excel";
               
                string tab = string.Empty;

                foreach (DataColumn datacol in dtRecords.Columns)
                {
                    context.Response.Write(tab + datacol.ColumnName);
                    tab = "\t";
                }
                context.Response.Write("\n");

                foreach (DataRow dr in dtRecords.Rows)
                {
                    tab = "";
                    for (int j = 0; j < dtRecords.Columns.Count; j++)
                    {
                        context.Response.Write(tab + Convert.ToString(dr[j]));
                        tab = "\t";
                    }

                    context.Response.Write("\n");
                }
                context.Response.End();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

ManojDhobale · Answer 3 · 2014-04-22T02:03:00

Solution 3

refer this
http://www.aspsnippets.com/forums/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx#[^]

Posted 22-Apr-14 2:03am

ManojDhobale