Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting 2 byte character data from jsp to excel

Suhana Nanda
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I would request any help on the following.
How to export 2 BYTE character data that is displayed in a JSP to an Excel spreadsheet ?I am working on a multilingual application with Oracle as the back end. I want to export the data both in English and japnese. The code written below, displays the data in English(in excel),but in case of japnese , it shows junk characters.

<body >

<%String strData=request.getParameter("va"); // the variable va has the data (in html format) that I want to print in the excel in the html .

byte[] buffer1 = null;
strData = new String(strData.trim().getBytes("ISO_8859_1"), "Shift_JIS");
buffer1= strData.getBytes();
response.setContentType("application/xls; charset=Shift-JIS");//set the content type


response.setHeader("Content-Disposition", "attachment;filename=" + attached_filename + ";size=" + buffer1.length + "");


PrintWriter pw =new PrintWriter(out);
catch(Exception e)

Please suggest me a way out?

Sample code would be appreciated.Thanks in advance.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic