Iâm using this code to export data from a repeater to an Excel sheet:
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
Excel sheet when is displayed contains data from repeater, notwithstanding accents and Spanish letter Ã± containing within data are not drawing correctly, e.g.:
MÃ©xico it is drawing as MÃÂ©xico
LÃ³pez it is drawing as LÃÂ³pez
VillafaÃ±a it is drawing as VillafaÃÂ±a
MarÃa it is drawing as MarÃa
Â¿Does somebody knows what is the reason about it and how can I fix it?
Iâll appreciate your help.
El Hombre que tiene Amigos ha de mostrarse Amigo