Silverlight3.0 导数据到Excel 出现中文乱码

[sez8852]

mSaveFileDialog = new SaveFileDialog();
mSaveFileDialog.Filter = "(Excel文件)*.xls|*.xls|*.txt|*.txt";
mSaveFileDialog.FilterIndex = 1;
if (mSaveFileDialog.ShowDialog().Value)
{
string mres = "";
string mWriteLine = "机器名称\t卖的数量\t赠的数量\t卖的钱数(RMB)";
mres += mWriteLine + "\r\n";// \n
foreach (OI.CETB_Customer_Collection temp in mCollectionList)
{
mWriteLine = temp.GlucometerCaption + "\t" + temp.CountSell + "\t" + temp.CountSend + "\t" + temp.Money;
mres += mWriteLine + "\r\n";
}
Stream aStream = mSaveFileDialog.OpenFile();
byte[] Bytes = (new UTF8Encoding(true).GetBytes(mres));
aStream.Write(Bytes, 0, Bytes.Length);
aStream.Close();
}

我保存成 XT文档时能正常保存，格式也正确
但我要保存到Excel中，中文的地方就出现乱码？怎么解决啊

[jv9]

byte[] Bytes = (new UTF8Encoding(true).GetBytes(mres));

可以试试用其他的编码，这个问题，没有试过，UTF8的编码转换后是容易出现乱码。

参考这篇文章，试试
http://www.cnblogs.com/WCFGROUP/archive/2009/06/10/1500187.html

[sez8852]

自己解决了
只要把if (mSaveFileDialog.ShowDialog().Value) 里的内容改为下面的代码就可以

Stream aStream = mSaveFileDialog.OpenFile();
StreamWriter mWrite = new StreamWriter(aStream, Encoding.Unicode);
mWrite.WriteLine("机器名称\t卖的数量\t赠的数量\t卖的钱数(RMB)");
foreach (OI.CETB_Customer_Collection temp in mCollectionList)
{
mWrite.WriteLine(temp.GlucometerCaption + "\t" + temp.CountSell + "\t" + temp.CountSend + "\t" + temp.Money);
}
mWrite.Flush();
mWrite.Close();
aStream.Close();

流的运用。

[xingjunli]

通常是编码格式导致的，解决了就好