Characters bad when exporting asp.net datagrid to excel

  • Thread starter Thread starter Goran Djuranovic
  • Start date Start date
G

Goran Djuranovic

Hi all,
When I export data from asp.net datagrid to excel spreadsheet, characters
such as "é" become "é". It looks like excel doesn't know how to convert
these.

Anyone?

TIA
 
Two things to try

1.) check your region settings. If you are exporting a french (as a
example) datagrid, try and enable French keyboard settings in region
in the control panel

2.) as a backup, just do a search and replace after the import an
replace the bad characters with the good. Not very efficient but i
works

Good luc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Export Gmail Emails to PST Format? 4
How to Export Datagrid view data to excel in ASP.net 3.5? 1
limit on number of characters? 1
Export Datagrid 1
Add additional header or data into excel after exporting - asp.net application 2
Exporting datagrid contents to Excel using ASP.NET 3
Exporting ALL data into Excel file with Page Navigation in ASP.NET 2

Back
Top