export datagrid to excel

microsoft.public.dotnet.languages.csharp

26 Mar 2005 1:17 AM

Mike P

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!