RE: Set character formatting in Excel using POI

[Lee, Jun S.]

I'm very new to POI but when I was looking through the API,
I saw you can do:

HSSFCell.getHSSFCellStyle() and HSSFCellStyle class has setFont.
That looks like changing style for a single cell.

Best,
Jun



-----Original Message-----
From: thomas908 [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 13, 2007 1:11 PM
To: user@poi.apache.org
Subject: Set character formatting in Excel using POI


I want to set some values in the excel sheet using POI. These values
must
have the required character formatting like bold, italics and underline.

Say, the value that I need to set in some cell in the excel could be
something like

italics plain boldItalics allThree<u> plain</u>


Whatever is there inside
.. should be set as italics
.. should be set as bold
<u>..</u> should be set as underline

I was trying to set this formatting by harcoding the indexes (for the
time
being) using the following code

String str="italics plain boldItalics allThree<u> plain</u>";
      
      HSSFWorkbook wb;
      
      void func()
      {
             try{
                      File writeXcel=new File("C:/newOUT.xls");
                        FileOutputStream fileOut = new
FileOutputStream(writeXcel);
                        wb=new HSSFWorkbook();
                        HSSFSheet sheet=wb.createSheet("Sheet 1");
                        HSSFRow row=sheet.createRow(0);
                        HSSFCell cell=row.createCell((short)0);
                  
                        HSSFRichTextString rts=new
HSSFRichTextString(str);
                        HSSFFont font=wb.createFont();
                        
                        font.setItalic(true);
                        font.setUnderline((byte)1);
                        font.setBoldweight((short)700);

                        rts.applyFont(0,5,font);
                        
                        font.setItalic(false);
                        font.setUnderline((byte)0);
                        font.setBoldweight((short)400);

                        rts.applyFont(6,11,font);
                        
                        font.setItalic(false);
                        font.setUnderline((byte)0);
                        font.setBoldweight((short)700);
                        rts.applyFont(12,16,font);
                        
                        cell.setCellValue(rts);
                        wb.write(fileOut);
                        fileOut.close();
             }catch(Exception e) {
                  e.printStackTrace();
             }
                        
      }
      

But it seems it cannot be done, once the font is set it is set for
everything.
Can someone please tell me how to resolve this.
Thank You
-- 
View this message in context:
http://www.nabble.com/Set-character-formatting-in-Excel-using-POI-tf4262
750.html#a12131092
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]