This post originated from an RSS feed registered with .NET Buzz by Paschal. Original Post: Encoding for export Feed Title: help.net Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/pleloup/Rss.aspx Feed Description: .Net for mankind ! Latest .NET Buzz Posts Latest .NET Buzz Posts by Paschal Latest Posts From help.net

Maybe this trick can help some developers who want to export a Dataset to Excel or Word. Well easy if you're in US without accent issue, but here in Ireland we have some nice accentuation in Irish.

So if you export by default a text containing 'Meánscoil Na mBráithre' using StreamWriter, you have a great chance to obtain this : 'Meánscoil Na mBráithre'

Wrong isn't it :-) So the right solution is to create your Streamwriter object including the correct Encoding (in VB.Net):

Dim objStreamWriter As StreamWriter = New StreamWriter(Server.MapPath(RelativePath+Nameofyourfile.xls), False, Encoding.Default)

The weird thing here is that Encoding.Default is not the same as doing nothing