September 6, 2008 10:30pm pdt

1. TheLearn... 273,600
2. Dhaest 127,682
3. jaime_oliv... 118,871
4. jcoehoorn 94,057
5. naspinski 76,640
6. emoreau 75,305
7. jpaulino 67,820
8. GreenGho... 66,010
9. samtran0... 63,295
10. raterus 63,050
11. Velio 53,140
12. avnish_t... 50,550
13. ZachSmith 46,850
14. angelIII 46,638
15. graye 45,235
16. tedbilly 43,814
17. VBRocks 42,000
18. webtubbs 41,160
19. prairiedog 39,700
20. pratima_... 38,979
21. Idle_Mind 37,825
22. JimBrandley 35,360
23. Sancler 35,250
24. Fernando... 35,020
25. ororiole 34,855

1. TheLearn... 639,978
2. samtran0... 242,610
3. Dhaest 213,205
4. surajguptha 200,972
5. jaime_oliv... 196,956
6. Idle_Mind 165,095
7. emoreau 144,440
8. jcoehoorn 112,357
9. jpaulino 105,650
10. JimBrandley 101,222
11. Fernando... 100,534
12. graye 90,549
13. McExp 89,513
14. DarkoLord 88,876
15. GreenGho... 87,260
16. angelIII 85,542
17. VBRocks 84,820
18. webtubbs 80,960
19. tedbilly 78,414
20. Sancler 77,532
21. naspinski 76,640
22. raterus 75,425
23. TSmooth 72,363
24. pratima_... 62,329
25. PaulHews 60,148

06.11.2008 at 12:08PM PDT, ID: 23477034

	[x] Attachment Details

Export Gridview to Excel sheet

Asked by rathiagu in .NET Framework 2.0, Microsoft Excel Spreadsheet Software, Programming for ASP.NET

Tags: microsoft, .net framework, 2.0

I used the below code to export two gridviews on a button click to excel sheet.the code was working fine and the only problem i had was the contents doesnot autofit inside excel sheet.i have attached the code in code snippet and the output excel sheet is attached as fileStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:

           
           
             protected void btn1_Click(object sender, EventArgs e)
    {
DisableControls(GridView1);
DisableControls(GridView2);
      
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
        Response.Charset = String.Empty; Response.ContentType = "application/vnd.ms-excel";
 
        System.IO.StringWriter sw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);
        GridView1.RenderControl(hw);
        Response.Write(sw.ToString());
 
        if (GridView2.Visible == true)
        {
            System.IO.StringWriter sw1 = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw1 = new HtmlTextWriter(sw1);
            GridView2.RenderControl(hw1);
            Response.Write(sw1.ToString());
 
        }
        Response.End();
}
 
 
private void DisableControls(Control gv)
    {
 
        LinkButton lb = new LinkButton();
 
        Literal l = new Literal();
 
        string name = String.Empty;
 
        for (int i = 0; i < gv.Controls.Count; i++)
        {
 
            if (gv.Controls[i].GetType() == typeof(LinkButton))
            {
 
                l.Text = (gv.Controls[i] as LinkButton).Text;
 
                gv.Controls.Remove(gv.Controls[i]);
 
                gv.Controls.AddAt(i, l);
 
            }
 
            else if (gv.Controls[i].GetType() == typeof(DropDownList))
            {
 
                l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;
 
                gv.Controls.Remove(gv.Controls[i]);
 
                gv.Controls.AddAt(i, l);
 
            }
            else if (gv.Controls[i].GetType() == typeof(Button))
            {
                gv.Controls.Remove(gv.Controls[i]);
            }
 
 
            if (gv.Controls[i].HasControls())
            {
 
                DisableControls(gv.Controls[i]);
 
            }
 
        }
 
    }

           
         

Attachments:

FileName-1-.xls (9 KB) (Possible File Type Mismatch)

output in excel sheet with contents not autofitted

Gridviewoutput.doc (736 KB) (File Type Details)

Gridview output in web page which has export to excel button.Only when that button is clicked the above excel sheet is seen.the code for this button click is given in code snippet

Keywords: Export Gridview to Excel sheet

	Title
1	generating Excel report from GridView …
2	Footer is missing in a gridview when it …
3	Need a macro to create sheet and cop…
4	Insert in a GridView
5	Bi-Directional Sorting in Gridview
6	WHERE IS Excel HISTORY SHEET kept?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Export Gridview to Excel sheet

Asked by rathiagu in .NET Framework 2.0, Microsoft Excel Spreadsheet Software, Programming for ASP.NET

Tags: microsoft, .net framework, 2.0

About this solution