Asp.net Export to Excel from GridView in 2007

Question

0.00/5 (No votes)

See more:

Hi,

Iam getting when export to excel in asp.net

The file you are trying to open is in a different format than specified by the file extension

C#

Response.ClearContent();
            Response.ContentType = "application/octet-stream";
            Response.AddHeader("Content-Disposition", "attachment; filename=Test.xls");

            GridView excel = new GridView();
            excel.DataSource = dt;
            excel.DataBind();
            excel.RenderControl(new HtmlTextWriter(Response.Output));

            Response.Flush();
            Response.End();

Thanks,
Krishna

Posted 25-Jun-13 20:44pm

Krishna KV

Updated 25-Jun-13 20:54pm

Thanks7872

v2

Add a Solution

2 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)

Thanks7872 · Answer 1 · 2013-06-25T20:51:00

Follow below steps:

1) Start Registry Editor.(run regedit.exe)

2) If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

3) Locate and then click the following registry subkey:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security

4) On the Edit menu, point to New, and then click DWORD Value.

5) Type ExtensionHardening, and then press ENTER.

6) Right-click ExtensionHardening, and then click Modify.

7) In the Value data box, type 0, and then click OK.

You are done.

:doh:[Another workaround]:

ClosedXML - The easy way to OpenXML[^]

[Update]:

Excel 2007 Extension Warning On Opening Excel Workbook from a Web Site[^]

Regards.. :laugh:

ErBhati · Answer 2 · 2013-06-25T21:14:00

C#

ds = //fill your dataset ds
        DataTable dt = new DataTable();
        dt = ds.Tables[0];
        string attachment = "attachment; filename=//givefilename";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/vnd.ms-excel";
        string tab = "";
        foreach (DataColumn dc in dt.Columns)
        {
            Response.Write(tab + dc.ColumnName);
            tab = "\t";
        }
        Response.Write("\n");
        int i;
        foreach (DataRow dr in dt.Rows)
        {
            tab = "";
            for (i = 0; i < dt.Columns.Count; i++)
            {
                Response.Write(tab + dr[i].ToString());
                tab = "\t";
            }
            Response.Write("\n");
        }
        Response.End();

Asp.net Export to Excel from GridView in 2007

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0