title: C# generated excel file - issue with special chars
body: <p>Firstly, here is my code:</p>
  
  <pre><code>DataTable usersReport = reportsService.GenerateUsersReport();
  
  var grid = new GridView();
  grid.DataSource = usersReport;
  grid.DataBind();
  
  Response.ClearContent();
  Response.Buffer = true;
  Response.AddHeader("content-disposition", "attachment; filename=UsersReport.xls");
  Response.ContentType = "application/ms-excel";
  
  Response.Charset = "";
  StringWriter sw = new StringWriter();
  HtmlTextWriter htw = new HtmlTextWriter(sw);
  
  grid.RenderControl(htw);
  
  Response.Output.Write(sw.ToString());
  Response.Flush();
  Response.End();
  </code></pre>
  
  <p>As you can see, I just generate in simply way report about users. When I open this file in excel, there is a problem with special chars, like <code>ś,ż,ź,ó,ę,ą</code> etc.</p>
  
  <p>Instead of <code>Imię</code> I can see <code>ImiÄ™</code>.
  The same issue with <code>GyÅ¼yÅ„ski</code></p>
  
  <p><br>
  How can I resolve it?</p>
  
  <p>EDIT:</p>
  
  <p>Add that lines:</p>
  
  <pre><code>Response.Charset = "";
  Response.ContentEncoding = System.Text.Encoding.Default;
  </code></pre>
  
  <p>Now <code>Imię</code> looks like <code>Imiê</code>. In conclusion - still nothing</p>