• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Issue with export to Excel in swedish locale

 
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Ranchers,

i have one issue when we do export to excel .
we set i18 locale of my application to swedish
Then export excelsheet i got garbage value insted of space in number format
eg number in sedish 82 123
in excel it show 82� 123

in this case insted of space it shows '�'
kindly help me ,Thanks in advanced
 
abhijit Ohal
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i don't know whether is it a excel issue or not
bcause before setting mime type to "application/vnd.ms-excel", numberformat is showing space correctly but once following steps are done & it get exported to excel & get special char '�'



can anybody help for this issue

Thanks in advanced once again
 
abhijit Ohal
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i tried with other charset i.e ISO8859-15 insted of UTF-8
see it but it is showing error & not accepting new charset
kindly let me know if anybody have nicer idea to solve this problem
 
It's feeding time! Give me the food you were going to give to this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic