Export DataTable to Excel File in asp.net

Question

I have read this article that exports datatable to excel file. It worked great.

and the code is below:

dt = city.GetAllCity();//your datatable 
string attachment = "attachment; filename=city.xls"; 
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();

But when I use this codes, the korean characters are all broken. Can anyone help me with this problem?

It may be down to Excel not recognising the unicode need to display the characters. You probably need a header to indicate that. — Simon Halsey
– Simon Halsey, Commented Oct 21, 2011 at 0:45
ContentType charset en.wikipedia.org/wiki/List_of_HTTP_header_fields#Responses make sure you include UTF8 as shown in the article — Simon Halsey
– Simon Halsey, Commented Oct 23, 2011 at 1:40

Nalaka526 · Accepted Answer · 2012-10-26 11:01:55Z

2

I use windows-1254 character set for Turkish. I guess KS_X_1001 will work for you. For more sets : http://en.wikipedia.org/wiki/Character_encoding

Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");
Response.Charset = "windows-1254";

edited Oct 26, 2012 at 11:01

Nalaka526

11.5k21 gold badges86 silver badges119 bronze badges

answered Mar 20, 2012 at 11:22

Erben

212 bronze badges

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

Collectives™ on Stack Overflow

Export DataTable to Excel File in asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related