The code below is used to get the content of a dataset to Excel and it
works quite okay, except:

Special Danish charachters look crappy when shown in Excel. Any ideas
if the problem can be solved?

response.Clear()
response.Charset = "iso-8859-2"
response.ContentType = "application/vnd.ms-excel"

Dim stringWrite As New System.IO.StringWriter
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)

Dim dg As New DataGrid
dg.DataSource = ds.Tables(0)
dg.DataBind()
dg.RenderControl(htmlWrite)

response.Write(stringWrite.ToString)
response.End()


Regards /Snedker
--
http://www.dbconsult.dk
http://www.vinthervej2.dk [private]

Thus wrote Morten Snedker morten_spammenot_ATdbconsult.dk,

> The code below is used to get the content of a dataset to Excel and it
> works quite okay, except:
>
> Special Danish charachters look crappy when shown in Excel. Any ideas
> if the problem can be solved?
>
> response.Clear()
> response.Charset = "iso-8859-2"

Don't use HttpResponse.Charset -- that has no effect on the actual encoding
being used (it just sets an attribute of the Content-Type header). Instead,
use

Response.ContentEncoding = Encoding.GetEncoding("iso-8859-2");

which also sets HttpResponse.Charset implicitly.

Cheers,
--
Joerg Jooss
news-(E-Mail Removed)

On Thu, 25 Jan 2007 21:08:12 +0000 (UTC), Joerg Jooss
<news-(E-Mail Removed)> wrote:

Can I call you honey? :-)

Just changed to iso-8859-1 and all is well. Thanks a bunch for the
iceing on the cake!

/Regards

>use
>Response.ContentEncoding = Encoding.GetEncoding("iso-8859-2");
>which also sets HttpResponse.Charset implicitly.

--
http://www.dbconsult.dk
http://www.vinthervej2.dk [private]