File name for Excel sheel not showing correctly in Japanese locale

[Kota Vardhini]

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]

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]

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]

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.