I’m using this code to export data from a repeater to an Excel sheet:

Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=Clientes.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
Repeater1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();

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.

A.L.


El Hombre que tiene Amigos ha de mostrarse Amigo

__________________
El Hombre que tiene Amigos ha de mostrarse Amigo

Nobody have had an experience such this one?


El Hombre que tiene Amigos ha de mostrarse Amigo

I think you need to set the charset to something that supports your characterset.

Try this:

Response.Charset = "UTF-8";

or replace UTF-8 with another appropriate character set.

Cheers,

Imar

Thanks you Imar:
I already tried with "utf-8", "iso-latin-1", "iso-8859-1" and "unicode" and trouble is still there.
Yet if I replace repeater with a datagrid it works ok.
What a strange thing
A.L.

El Hombre que tiene Amigos ha de mostrarse Amigo

That's interesting. Apparently, there is built-in support for other charactersets in the DataGrid, and not in the Repeater.

Is using a DataGrid an option for you?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

May be use datagrid would be an option, but I'm confused about why it do not work with repeater.
Maybe cultural settings?
A.L.

El Hombre que tiene Amigos ha de mostrarse Amigo

At last I found the way to achieve it:

Below this line:

Response.ContentType = "application/vnd.ms-excel";

I insert this line :

Response.ContentEncoding = System.Text.Encoding.UTF7;

I hope this be useful people having a similar trouble.

A.L.


El Hombre que tiene Amigos ha de mostrarse Amigo

Cool. Thanks for sharing. I am sure this can be useful.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.