Could you attach a simple sheet with these characters in a header (made by Excel)? This will let me see what they do in the header to try see what's needed.
Shawn -----Original Message----- From: Prakash Chudasama [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 9:29 AM To: Zlatan Hirovic Subject: Re: RE: UNICODE in Excel Header Parts by HSSF Hi Zlatan, We are fetching the data from database and then printing it to the standard output. Here is the snippet //Create work book HSSFWorkbook hwb = new HSSFWorkbook(); //Create sheet with appropriate name. HSSFSheet sheet1 = hwb.createSheet("ExportToExcel1"); //Create 0th row in the sheet for header HSSFRow row = sheet1.createRow((short)0); //Printing header and setting columnwidth. for(int i=0;i<headerFields.size();i++){ sheet1.setColumnWidth((short)i,(short)1000); HSSFCell testCell = row.createCell((short)i); testCell.setCellValue((String)headerFields.get(i)); } int rowCount = 1; while(rs !=null && rs.next()) { //Creating row for data. HSSFRow rowInfo = sheet1.createRow((short)rowCount); int cellCount = 0; // Printing the data for each header. for(int i=0;i<headerFields.size();i++){ String strVal = rs.getString(i+1); if(strVal == null) strVal = ""; //Printing the data and setting column width. sheet1.setColumnWidth((short)(cellCount),(short)1000); HSSFCell testCell = rowInfo.createCell((short)(cellCount)); testCell.setCellValue(strVal); cellCount++; } rowCount++; } I have tried to fetch the data for those field which has japanese character using following method String test16 = new String(rs.getBytes(i + 1),"UTF-16" ); String convertedStr = new String(test16.getBytes(),"UTF-8"); column[i] = convertedStr; but its not working. Can you tell me where i am wrong. Regards, PRakash. ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag ---- On Wed, 20 Apr 2005, Zlatan Hirovic ([EMAIL PROTECTED]) wrote: > Hi, Prakash > > My Problem focus on "multibyte character in Excel Header or Footer Parts". > Normally, Japanese character(multibyte one) can be set to "Cell" or > "Sheet". > > Could you tell me your source ? > > Zlatan > > > > >Hi Zlatan, > > > >I have similar kind of problem. I am using POI to export the > >data from JSP. We have some japanese characters in data which > >needs to be print on to excel. It's not printing and display as > >a junk character. Can you tell me how to resolve this issue. > > > >REgards, > >Prakash. > > > > > > > > > >________________________________________________ > >Get your own "800" number > >Voicemail, fax, email, and a lot more > >http://www.ureach.com/reg/tag > > > > > >---- On Wed, 20 Apr 2005, Zlatan Hirovic ([EMAIL PROTECTED]) > >wrote: > > > > > Hi, all > > > > > > I found Bug Report about it. > > > http://issues.apache.org/bugzilla/show_bug.cgi?id=17039 > > > > > > With this patch, I could resolve this problem. > > > I wish that this patch should be used in latest version... > > > > > > Zlatan Hirovic > > > > > > > > > > >Hi, > > > > > > > >I'm investigating Excel by Jakarta POI (HSSF). > > > >How can I write UNICODE character in Excel Header or Footer > >Part ? > > > >(I know UNICODE character put in CELL or Sheet by > >'setEncoding'...) > > > > > > > >Regards > > > > > > > >Zlatan > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > >To unsubscribe, e-mail: > >[EMAIL PROTECTED] > > > >Mailing List: > >http://jakarta.apache.org/site/mail2.html#poi > > > >The Apache Jakarta Poi Project: > >http://jakarta.apache.org/poi/ > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > To unsubscribe, e-mail: > >[EMAIL PROTECTED] > > > Mailing List: > >http://jakarta.apache.org/site/mail2.html#poi > > > The Apache Jakarta Poi Project: > >http://jakarta.apache.org/poi/ > > > > > > > > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >Mailing List: http://jakarta.apache.org/site/mail2.html#poi > >The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
