Hi Zlatan, Thanks for your help. It does work for me.
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 > > If you use MultiByte Character, > you need to add > "testcell.setEncoding(HSSFCell.ENCODING_UTF_16)" > before > "testCell.setCellValue(strVal);" in your source. > > Zlatan > > > >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/ > > > --------------------------------------------------------------------- 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/
