Gridview Export to excel

Question

0.00/5 (No votes)

See more:

Hi
I need to export gridview data to an excel file and for this I have written below code.

try
           {
               System.Web.UI.HtmlControls.HtmlForm form = new System.Web.UI.HtmlControls.HtmlForm();
               string attachment = "attachment; filename=MQDeatils_Homer.xls";
               Response.ClearContent();
               Response.Buffer = true;
               Response.AddHeader("content-disposition", attachment);
               Response.ContentType = "application/vnd.ms-excel";
               StringWriter stw = new StringWriter();
               HtmlTextWriter htextw = new HtmlTextWriter(stw);
               form.Controls.Add(gvMQReport);
               this.Controls.Add(form);
               form.RenderControl(htextw);
               Response.Write(stw.ToString());
               Response.End();
           }
           catch(Exception ex)
           {}

After I save and open this excel file I am getting an excel error:
"Excel cannot open this file because the file format is not valid"

1) How can I resolve this?
2) If user doesn't have excel 2003 (above code I wrote for 2003 (xls not xslx)) and having higher versions like 2007 or 2010, how to handle that?

Can anybody please help on above questions

Posted 31-Aug-10 1:17am

yadlaprasad

Updated 31-Aug-10 1:20am

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 31-Aug-10 7:20am

Edited for Grammar.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Lantei · Answer 1 · 2010-08-31T01:56:00

Solution 3

ok add the following to your code..

C#

Response.Charset="";
//set the Charset to ""

Response.ContentType="application/vnd.xls";
// Alter the content-type to this

Response.Cache.SetCacheability(HttpCacheability.NoCache);
// and set the cacheability

and I believe it shouldnt give you problems anymore..:)

Posted 31-Aug-10 1:56am

Lantei

Comments

yadlaprasad 31-Aug-10 8:24am

Hi thanks for your response even i added the above code lines no use. is there any alternative? still i am getting same invalid format

Md. Marufuzzaman · Answer 2 · 2010-08-31T01:31:00

Solution 2

Try the link below:
Link-1[^]

Posted 31-Aug-10 1:31am

Md. Marufuzzaman

**Dalek Dave** · Answer 3 · 2010-08-31T01:22:00

Solution 1

2007 and higher will still open 2003, there is no problem there.

Posted 31-Aug-10 1:22am

Dalek Dave

Gridview Export to excel

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Gridview Export to excel

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us