export to excel with special characters

[Michael Haberfellner]

hi everyone!

i have to export an allready build csv-text into excel. works fine, but
when it comes down to displaying special characters (umlaute - as i'm
from austria where we use those shitty little things my code fails.

in the variable "locCSV" the text is correct, as if i put it onto screen
with response.write the characters are displayed perfect!

here is the code i'm using:

Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "UTF-8";
Response.AddHeader("content-disposition","attachment;filename=Export.csv");
System.IO.StringWriter locStringWriter = new System.IO.StringWriter();
locStringWriter.GetStringBuilder().Append(locCSV);
Response.Write(locStringWriter.ToString());
Response.End();

i've searched the internet and tried a lot of things. but nothing
worked. could anyone of you help me please?

thanx and greetings from vienna

mike

 

[mohanprajapati2006]

Code for Export datatable to csv in asp.net

Hello,

I had written the code for exporting the datatable into excel. You can find the code at link given below
http://aspnet-ajax-aspnetmvc.blogspot.com/2011/06/export-datatable-to-excel-with-special.html


Mohan Prajapati
(e-mail address removed)
http://aspnet-ajax-aspnetmvc.blogspot.com

 

[mohanprajapati2006]

exporting the datatable into excel

Hello,

I had written the code for exporting the datatable into excel. You can find the code at link given below



Mohan Prajapati