Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

excel vs html or the war of contentTypes  RSS feed

 
Asher Tarnopolski
Ranch Hand
Posts: 260
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
folks,
in my webapp a user can send to mysql db strings in english, hebrew or russian (more "non-latin" languages in the future).
when i display a data from the db in html format (<%@ page contentType="text/html"%>
everything is fine and all of the languages are shown as they should be.
when i display the same data in excel ((<%@ page contentType=""application/vnd.ms-excel"%>
english is still ok, but other languages turn into gibberish.
i tried to play with encodings , but it didn't help.
did anyone make a research of this stuff?
thanx.
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have nothing to back up this answer, more of a hunch:
I am guessing either
1) default language attributes of excel (MS program) causing the problem
2) excel not supporting the font being used
3) And last but not least: your computer was taken over by an alien who is flying over your house in a UFO covered in Green Peace bumper stickers.
Eric
 
Asher Tarnopolski
Ranch Hand
Posts: 260
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hey eric,
i was also thinking about the third possibility...
in any case, the m$ excel language settings are local for each client, i can't do anything about that. i was just wondering if anyone has broken this with some kind of bytes game or whatever else...
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!