I'm uploading a text file (.csv) dynamically to the client with this method
:
--
Response.Clear();
Response.AddHeader("Content-disposition:", "attachment;
filename=export.csv");
Response.AddHeader("Content-type", "application/vnd.ms-excel");
Response.ContentEncoding = Encoding.UTF8;
Response.Write([...]);
Response.Write([...]);
Response.End();
--
Some accentuated acharacters does not display correctly in excel... but when
I open the file the characters are displayed fine.. and notepad tells me
that the file is indeed a UTF-8 file (when file/save as)..
Im I missing something here? (apparently yes!)
Thanks guys (and or gals)
Mike
I've managed to get it done by:
Response.AddHeader("Content-disposition:", "attachment;
filename=export.csv");
Response.AddHeader("Content-type", "application/vnd.ms-excel;
charset=ISO-8859-1");
Response.Charset = "ISO-8859-1";
Response.ContentEncoding = Encoding.GetEncoding("ISO-8859-1");
I don't really need UTF8... my text was in latin iso :|
Mike