export file with correct encoding

Question

I don't understand what is missing here. I am trying to export a file in csv format with extended ASCII characters like ÿ or ü but all i get is �
Do I need to specify something else in the response?

Encoding encoding = Encoding.UTF8;

//ToCSV writes the string correctly
var bytes = encoding.GetBytes("write ÿ or ü please");
MemoryStream stream = new MemoryStream(bytes);

StreamReader reader = new StreamReader(stream);
//TextWriter tw = new TextWriter();
Response.Clear();
Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.csv", fileName));
Response.Charset = encoding.EncodingName;
Response.ContentType = "application/text";
Response.Output.Write(reader.ReadToEnd());
Response.Flush();
Response.End();

Are you sure the client is using the right encoding to display the output? — marcind
– marcind, Commented Apr 8, 2011 at 3:43
I assume that by "all I get is �" you mean that is what you see in the browser. Have you examined the headers that your browser is receiving? — Joel Lee
– Joel Lee, Commented Apr 8, 2011 at 4:01

Majid · Accepted Answer · 2017-02-22 07:47:48Z

23

I believe you should add Response.ContentEncoding = Encoding.Unicode to get right output.

    Encoding encoding = Encoding.UTF8;
    var bytes = encoding.GetBytes("write ÿ or ü please");
    MemoryStream stream = new MemoryStream(bytes);
    StreamReader reader = new StreamReader(stream);
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.csv", "filename"));
    Response.Charset = encoding.EncodingName;
    Response.ContentType = "application/text";
    Response.ContentEncoding = Encoding.Unicode;
    Response.Output.Write(reader.ReadToEnd());
    Response.Flush();
    Response.End();

edited Feb 22, 2017 at 7:47

Majid

14.3k16 gold badges81 silver badges117 bronze badges

answered Apr 8, 2011 at 7:12

Özgür Kaplan

2,1562 gold badges16 silver badges26 bronze badges

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

2 Comments

kiev Over a year ago

It was actually specifying the charset by Response.Charset = encoding.BodyName;

SergeyT Over a year ago

encoding.WebName should be used here. BodyName gives incorrect value for some encodings. For example, "koi8-r" for "windows-1251" encoding.

Chtioui Malek · Accepted Answer · 2014-12-22 13:16:48Z

6

Unfortunately Encoding.Unicode didn't work, using Windows-1252 worked :

Response.Clear();
Response.ContentType = "Application/x-msexcel";
Response.AddHeader("content-disposition", "attachment; filename=\"filename.csv\"");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252");
Response.Write(string.Join(Environment.NewLine, myDataLines));
Response.End();

edited Dec 22, 2014 at 13:16

answered Dec 22, 2014 at 13:11

Chtioui Malek

11.5k1 gold badge76 silver badges70 bronze badges

Comments

Lenik · Accepted Answer · 2011-04-08 04:03:25Z

0

I'm a Java programmer, are you sure you need a StreamReader? I guess StreamReader(stream) may decode the bytes in a different charset. And, You've already got the bytes, maybe you could write the bytes to response directly.

answered Apr 8, 2011 at 4:03

Lenik

14.6k17 gold badges81 silver badges104 bronze badges

1 Comment

kiev Over a year ago

Maybe there is, but I am not sure how to do that. I will give it a try.

Collectives™ on Stack Overflow

export file with correct encoding

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related