Export ANSI Char to Excel

[nadraj_suresh]

My application displays non-unicode (ANSI) data for Traditional
Chinese using Browser Encoding.

However, When I export the data into Excel by setting the content type as:

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

The data moved to the Excel is not Chinese. It's in the same format as in the
data base.

Any Soultion to display the Chinese Chareters in Excel as in the Browser ?

Thanks !!!