Exporting to Excel with Unicode data

B

Bernard O'Flynn

Hi
I'm trying to get the datagrid to excel export working. I've used the usual
code examples that are floating around and it all works fine.
The only problem is that I have multiple languages in the datagrid (one of
them being Greek).
When I open the exported Excel file in Excel, I get weird characters in some
places - umlauts(?) in German as an example.
I need to then go to the Excel Options and choose to re-open the file as
Unicode and then the file displays correctly.

Obviously I can't ask every user to do this - does anyone have any solution
for this?

Regards,
Bernard
 
Joined
Aug 22, 2007
Messages
1
Reaction score
0
Add the follwing line

Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">");
 

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

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,906
Latest member
SkinfixSkintag

Latest Threads

Top