Export to excel and special characters

[Tim]

I am exporting a dataset to Excel.

I can successfully view the dataset in Excel however, there are
special characters that are appearing in the form of Â, â€" and
others.

My code in C# starts off like this:

Response.Clear();

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

Response.AddHeader("content-disposition",
"attachment;filename=GeneralInquiry.xls");


I've tried setting the Response.Charset = "" but that doesn't do
anything either.

Would anyone know what could be causing this and/or how to fix it?

Thank you.

-Tim

 

[Guest]

I am having the exact same error did you ever find a solution. I'd be grateful for any help.

Sam

I am exporting a dataset to Excel.
special characters that are appearing in the form of Â, â€" and
others.
> Response.AddHeader("content-disposition",
"attachment;filename=GeneralInquiry.xls");

User submitted from AEWNET (http://www.aewnet.com/)

 

[mohanprajapati2006]

Hello,

I had written the code for exporting the datatable into excel. You can find the code at link given below
http://aspnet-ajax-aspnetmvc.blogspot.com/2011/06/export-datatable-to-excel-with-special.html


Mohan Prajapati
(e-mail address removed)
http://aspnet-ajax-aspnetmvc.blogspot.com