• Post Reply Bookmark Topic Watch Topic
  • New Topic

File name for Excel sheel not showing correctly in Japanese locale

 
Kota Vardhini
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Following is the piece of code which I am setting the filename to excel from jsp:

response.setContentType("application/x-msexcel;charset=UTF-8");
response.setHeader("Content-disposition", "attachment; filename=" +URLEncoder.encode(filename,"UTF-8"));

My Issue: I am able to set Japanese characters filename to excel sheet properly but
not able to set proper tab name, its showing the value of tab name with "%" characters, its seems the excel is not properly decoding the endoced characters. Could anyone suggest the filename and the tab name which supports proper japanese name.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I understand correctly you are saying this problem is with excel and not with the servlet that writes the excel right ? Not sure how excel handles i18n really. More of a microsoft product related question if my understanding of your question is correct
 
Kota Vardhini
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Deepak Bala wrote:If I understand correctly you are saying this problem is with excel and not with the servlet that writes the excel right ? Not sure how excel handles i18n really. More of a microsoft product related question if my understanding of your question is correct


Thanks Deepak.

Is there any way to get the Japanese excel name and tabname with out using URLEncoding. I need a solution that supports UTF-8 to the filename.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Where these japanese characters are required is still a gray area for me.

Are these character required in

  • The file name
  • A particular tab inside the excel sheet that represents a workbook
  • A particular cell inside the excel that contains data


  • From what I understand so far you are able to get the file name to appear properly but the tab name in the excel sheet is not displaying as expected, which is more of a microsoft product question than a question on JSPs.
     
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!