Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Issue with export to Excel in swedish locale  RSS feed

 
abhijit Ohal
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!