globalization problem? Chinese words can't be displayed correctly after export to Excel file RSS

• • Reply
  

  ywang27

  Member

  20 Points

  4 Posts

  globalization problem? Chinese words can't be displayed correctly after export to Excel file

  Aug 07, 2003 07:50 AM|LINK

  Hi, does anybody know how to fix this problem, I export my datagrid to Excel file, but because my one of columns is chinese name, the excel file can't display the chinese words. I tried to use some attributes of response, doesn't work. Help!

  Response.ContentType="application/vnd.ms-excel";
  	    
  
              Response.AddHeader("Content-Disposition", "attachment;filename=SupplierProfile.xls;") ;
      
  
              Response.Charset=" ";
              Response.Buffer = false ;
              Page.EnableViewState=false;
              System.IO.StringWriter tw=new System.IO.StringWriter();
      
  
              System.Web.UI.HtmlTextWriter hw=new System.Web.UI.HtmlTextWriter(tw);
      
  
              dbGrid1.RenderControl(hw);
      
  
              Response.Write(tw.ToString());
      
  
              Response.End();