I'm exporting a datagrid to excel, but I can't get non-English
characters such as ö, ä and å to appear properly in the Excel document
(they are fine on my webpage). Here is my code :
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "iso-8859-1";
this.EnableViewState = false;
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
this.ClearControls(dgTranslation);
dgTranslation.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
Can anybody help me out with this?
Cheers,
Mike
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!