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
 
Back
Top