Question

asp.net 导出 excelle 出现中文乱码

StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
this.GvData.RenderControl(htw);
string strHtml = sw.ToString().Trim();

string ExcelFileName = "商品" + DateTime.Now.Date.ToString("yyyyMMdd") + ".xls";
string FilePhysicialPathName = Request.PhysicalApplicationPath + "/xls";

//生成的Excel文件名
string objectExcelFileName = Path.Combine(FilePhysicialPathName, ExcelFileName);

if (File.Exists(objectExcelFileName))//如果有此文件,先删除
{
File.Delete(objectExcelFileName);
}
FileStream fs = new FileStream(objectExcelFileName, FileMode.Create);
BinaryWriter bw = new BinaryWriter(fs, Encoding.GetEncoding("GBK"));
Response.Charset = "GBK";

bw.Write(strHtml);
bw.Close();
fs.Close();
Response.Redirect("../xls/商品管理" + DateTime.Now.Date.ToString("yyyyMMdd") + ".xls");

Answer 1

绑定到DataTable的代码
cboCardType.DataSource = myDataTable;//绑定记录集
cboCardType.DisplayMember = "NameColName";//设置显示的字段
cboCardType.ValueMember = "IDColName";//设置值字段

Answer 2

Response.Clear()
Response.Buffer = True
Response.Charset = "GB2312"
Response.AppendHeader("Content-Disposition", "attachment;filename=ColourVision_Shop.xls")
Response.ContentEncoding = System.Text.Encoding.UTF7
Response.ContentType = "application/ms-excel"
Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
Me.GridView1.RenderControl(oHtmlTextWriter)
Response.Output.Write(oStringWriter.ToString)
Response.Flush()
Response.End()

Answer 3

将 Encoding.GetEncoding("GBK") 改为 ASCIIEncoding.GetEncoding("gb2312") 试试!
Response.Charset = "GBK" 也改成 Response.Charset = "gb2312" ; 试试

Answer 4

呵呵，这个问题我也遇到过。你把：gb2312改为utf-7就ok了。