Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Problem with diacritic characters when exporting data to Excel

Reply
Thread Tools

Problem with diacritic characters when exporting data to Excel

 
 
ChrisN
Guest
Posts: n/a
 
      09-19-2006
My app displays a dataset in a GridView and also exports it to Excel.
Characters with diacritical marks (eg umlaut) show up just fine in the
GridView but are mangled when exported to Excel.

Eg

HKS FŲrdertechnik AG

becomes

HKS Fördertechnik AG

Here's a cut-down version of the export code:

response.Clear()
response.AddHeader("Content-Disposition",
"attachment;filename=" & "InvoiceData.csv")
response.ContentType = "application/vnd.ms-excel"
response.Charset=""
response.Write(ConvertDataViewToString(_exportData )) '
response.End()

Since the data looks okay in the database, and everything is in UNICODE
all the way through to Excel, what am I doing wrong?

Thanks,

Chris N

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Script for finding words of any size that do NOT contain vowels withacute diacritic marks? nwaits Python 10 10-17-2012 06:33 PM
Exporting to Excel with Chinese Characters tarunbajaj@gmail.com ASP .Net Datagrid Control 0 10-14-2005 11:29 PM
Dodgy Characters Exporting to Excel postings@alexshirley.com ASP .Net 2 09-26-2005 03:41 PM
Handling special characters when exporting DataGrid to Excel Elisabeth Svensson via .NET 247 ASP .Net Datagrid Control 1 12-21-2004 11:46 AM
Characters bad when exporting asp.net datagrid to excel Goran Djuranovic ASP .Net 0 12-10-2004 06:44 PM



Advertisments