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

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)

**Dalek Dave** · Answer 1 · 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

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

Lantei · Answer 3 · 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