• 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

File name for Excel sheel not showing correctly in Japanese locale

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
     
    Don't get me started about those stupid light bulbs.
    reply
      Bookmark Topic Watch Topic
    • New Topic