error message after converting datatable to excel in asp.net c#

Question

below code i am using

 Response.ClearContent();
    Response.Buffer = true;
    Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
    Response.ContentType = "application/ms-excel";
    DataTable dt = ds.Tables[0];
    string str = string.Empty;
    foreach (DataColumn dtcol in dt.Columns)
    {
        Response.Write(str + dtcol.ColumnName);
        str = "\t";
    }
    Response.Write("\n");
    foreach (DataRow dr in dt.Rows)
    {
        str = "";
        for (int j = 0; j < dt.Columns.Count; j++)
        {
            Response.Write(str + Convert.ToString(dr[j]));
            str = "\t";
        }
        Response.Write("\n");
    }
    Response.End();

error message is

  ![Your trying to open different format or corrupted file ][2]

enter image description here

its opening after clicking ok but i dnt want showing this message .... where i made error... thank you...

Community · Accepted Answer · 2017-05-23 10:32:36Z

0

Your content type is wrong. You are creating a CSV output, not Excel. Change content type to text/csv and file extension to .csv.

How to use the CSV MIME-type?

Link to OpenXML SDK which let's you create any Office format: http://msdn.microsoft.com/en-us/library/office/bb448854%28v=office.15%29.aspx

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jan 9, 2015 at 5:07

Darek

4,80734 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

temp sun Over a year ago

could pls tell me how can i generate excel ?

Collectives™ on Stack Overflow

error message after converting datatable to excel in asp.net c#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related