Character display problem importing into Excel

[RateTheBuilder]

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
=========================================

 

[grahammal]

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.

 

[RateTheBuilder]

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
=========================================