export dataset to excel

[Guest]

Hello,

I have a dataset that has information written in Swedish language, that
means alot of stranch chars like 'Å, Ä, Ö' etc and my code
void Export(datagrid myDataGrid){
Response.Clear();

Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
myDataGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();}
this exports a file and replaces the swedish chars to something else like
ö.. Do you have any code sample or idea how to fix that???

 

[Mark Rae [MVP]]

Response.Charset = "";

Is that not the problem...? Don't you have to specify a value for Charset
here...?

 

[Guest]

hi mark
what should it be???
Response.charst = "ASCII" is not helping?

 

[Guest]

hi mark
what should it be???
Response.charst = "ASCII" is not helping?
--
LZ






- Show quoted text -

Hej Lamis

try to set encoding

Response.ContentEncoding = System.Text.Encoding.GetEncoding(1252)

 

[Mark Rae [MVP]]

hi mark
what should it be???
Response.charst = "ASCII" is not helping?

First, I would try:

Response.Charset = "iso-8859-1";

If that doesn't work, then try adding a ResponseEncoding tag to the @Page
directive e.g.

<%@ Page ContentType="text/html" ResponseEncoding="iso-8859-1">

See here:
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21551614.html

 

[Guest]

hi,

Response.ContentEncoding = System.Text.Encoding.GetEncoding(1252) worked
perfectly.. thank's ALOT for your help