Hi

I am trying to import data into excel from an ASP.Net page and everything is
working except for when text in a column contains é character. When the data
is imported into Excel it comes up as é instead.

In the code I am formating the cells as text using the following code:

<style.text { mso-number-format:\@; } </style

Anyone any idea what the problem could be? Or can I provide any more
information to help with a solution?

Thanks

Brendan
______________________________________________
Rate your experiences with your UK and Ireland builders at
http://www.ratethebuilder.co.uk
=========================================

It appears that what you want is ASCII code 233 to display but are
gettig ASCII code 227 + 169. Not sure why yet but am giving it some
more though.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=564612

Hi

Managed to solve the problem by adding the following line to my code:

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

Brendan
______________________________________________
Rate your experiences with your UK and Ireland builders at
http://www.ratethebuilder.co.uk
=========================================



"RateTheBuilder" wrote in message
...
Hi

I am trying to import data into excel from an ASP.Net page and everything
is working except for when text in a column contains é character. When the
data is imported into Excel it comes up as é instead.

In the code I am formating the cells as text using the following code:

<style.text { mso-number-format:\@; } </style

Anyone any idea what the problem could be? Or can I provide any more
information to help with a solution?

Thanks

Brendan
______________________________________________
Rate your experiences with your UK and Ireland builders at
http://www.ratethebuilder.co.uk
=========================================