Charset problem (dataset to excel)

[Morten Snedker]

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

 

[Joerg Jooss]

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,

 

[Morten Snedker]

On Thu, 25 Jan 2007 21:08:12 +0000 (UTC), Joerg Jooss

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