Exporting to Excel with Unicode data

Discussion in 'ASP .Net Datagrid Control' started by Bernard O'Flynn, Aug 11, 2004.

  1. 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
    Bernard O'Flynn, Aug 11, 2004
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    1
    Views:
    1,872
    Alvin Bruney [MVP]
    May 10, 2004
  2. Bernard O'Flynn

    Exporting to Excel with Unicode data

    Bernard O'Flynn, Aug 11, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    6,388
    bmgty
    Aug 22, 2007
  3. http://www.visual-basic-data-mining.net/forum

    Exporting Datagrid's data to an Excel Sheet.

    http://www.visual-basic-data-mining.net/forum, Oct 25, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    572
    Steve C. Orr [MVP, MCSD]
    Oct 25, 2004
  4. Luis Esteban Valencia
    Replies:
    1
    Views:
    1,360
    Carl Prothman [MVP]
    Jan 12, 2005
  5. Doogie
    Replies:
    1
    Views:
    435
    sloan
    Nov 19, 2008
Loading...

Share This Page