i m exporting gridview into excel but its not working i dnt knw why?should i have to override any render function for this?

Question

0.00/5 (No votes)

See more:

i m exporting gridview into excel but its not working i dnt knw why?
By using the code that is->

C#

try
        {
            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);
            gv_appt.AllowPaging = false;
            // gv_Employes.DataBind();
            //Change the Header Row back to white color
            gv_appt.HeaderRow.Style.Add("background-color", "#FFFFFF");
            //Applying stlye to gridview header cells
            for (int i = 0; i < gv_appt.HeaderRow.Cells.Count; i++)
            {
                gv_appt.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 gv_appt.Rows)
            {
                gvrow.BackColor = Color.White;
                if (j <= gv_appt.Rows.Count)
                {
                    if (j % 2 != 0)
                    {
                        for (int k = 0; k < gvrow.Cells.Count; k++)
                        {
                            gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
                        }
                    }
                }
                j++;
            }
            foreach (GridViewRow row in gv_appt.Rows)
            {
               
                LinkButton appgenrt = (LinkButton)row.FindControl("lbtn_apptGenerate");
                LinkButton email = (LinkButton)row.FindControl("lbtn_email");
                LinkButton edit = (LinkButton)row.FindControl("btn_editappt");
                LinkButton del = (LinkButton)row.FindControl(" btl_aapdlt");
                appgenrt.Visible = false;
                email.Visible = false;
                edit.Visible = false;
                del.Visible = false;
                gv_appt.Columns[7].Visible = false;
                gv_appt.Columns[8].Visible = false;
                gv_appt.Columns[9].Visible = false;
                gv_appt.Columns[10].Visible = false;
            }
            gv_appt.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();
        }
        catch { }

Posted 16-Nov-11 18:09pm

Member 8387468

Updated 16-Nov-11 18:31pm

uspatel

v3

Add a Solution

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)

Anurag Gandhi · Answer 1 · 2011-11-16T19:23:00

Solution 3

If you are getting error: "Control 'gv_appt' of type 'GridView' must be placed inside a form tag with runat=server.", then
you need to place the following method in your code behind:

C#

public override void VerifyRenderingInServerForm(Control control)
{
    //You may keep it empty. But needed.//
}

Click here[^] for detail.

Posted 16-Nov-11 19:23pm

Anurag Gandhi

Comments

Member 8387468 21-Nov-11 5:38am

ok mam i have used this code already but used tab container tool of ajax in that container there are 4 tab panels & each tab panel has 1 gridview and 1 imagebutton on the click of that image button i want to change gridview into excel and this image button is used on each tab panel.so have done the coding to change gridview to excel.can you tell me should i have to make the this method for all image button means for all methods that are make individually for all gridview to excel...?

Member 8387468 21-Nov-11 5:42am

sorry actly sir

Neha Thanka · Answer 2 · 2011-11-16T18:17:00

C#

myDataGrid.Visible = true;
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.ContentType = "application/vnd.xls";

            System.IO.StringWriter stringWrite = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

            myDataGrid.RenderControl(htmlWrite);
            Response.Write(stringWrite.ToString());
            Response.End();
            myDataGrid.Visible = false;

Add export class library to your project..
Refer the following link:
C# class library for exporting data to CSV/Excel file[^]

Prince Antony G · Answer 3 · 2011-11-16T18:38:00

http://ramanisandeep.wordpress.com/2009/04/07/export-gridview-to-excel/[^]

How to export GridView to Excel, render cells, add WordArt, and fill a custom template[^]

http://geekswithblogs.net/azamsharp/archive/2005/12/21/63843.aspx[^]

http://blogs.msdn.com/b/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx[^]

i m exporting gridview into excel but its not working i dnt knw why?should i have to override any render function for this?

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0