急急急！导出EXCEL时空格变成了问号？什么原因啊

Question

#region ExportToExcel
    private void ExportToExcel()
    {
        Hashtable ht = new Hashtable();
        ht["FileName"] = string.Format("{0}.xls", this.lblCaption.Text);
        MakeExcel me = new MakeExcel(ht);
              string stream = "";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);        
        this.tblMain.RenderControl(oHtmlTextWriter);
        stream = oStringWriter.ToString();
        
        me.AddContent(stream);
        me.Close();
        this.OpenWindow(string.Format("../{0}", me.GetExcelUrl()));
    }
    #endregion

Answer 1

curContext.Response.ContentEncoding = System.Text.Encoding.UTF8; 
指定字符集编码

Answer 2

参见下这篇文章
http://topic.csdn.net/u/20090701/11/ac194b12-369d-4bf4-b92c-9ce2f564479f.html

Answer 3

与Response没关系
给HtmlTextWriter指定编码

Answer 4

在后台请用“合    计：”不要用“合  计”