Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Multi line text
Date: Tue, 6 Jun 2006 15:47:09 -0700
Message-ID: 
 <3F243AF6C4C61A42A80C9AECF3A4018501DD9EFE@cpmal00.corpnet.p1.local>
Thread-Topic: Multi line text
Thread-Index: AcaJujy5Xbwfj7rNQu2nW11Stek05wAAMcgw
From: "Nidhi Tuli" <ntuli@paymentone.com>
To: "POI Users List" <poi-user@jakarta.apache.org>

You can look at http://jakarta.apache.org/poi/hssf/quick-guide.html


Using newlines in cells
    HSSFWorkbook wb =3D new HSSFWorkbook();
    HSSFSheet s =3D wb.createSheet();
    HSSFRow r =3D null;
    HSSFCell c =3D null;
    HSSFCellStyle cs =3D wb.createCellStyle();
    HSSFFont f =3D wb.createFont();
    HSSFFont f2 =3D wb.createFont();

    cs =3D wb.createCellStyle();

    cs.setFont( f2 );
    //Word Wrap MUST be turned on
    cs.setWrapText( true );

    r =3D s.createRow( (short) 2 );
    r.setHeight( (short) 0x349 );
    c =3D r.createCell( (short) 2 );
    c.setCellType( HSSFCell.CELL_TYPE_STRING );
    c.setCellValue( "Use \n with word wrap on to create a new line" );
    c.setCellStyle( cs );
    s.setColumnWidth( (short) 2, (short) ( ( 50 * 8 ) / ( (double) 1 /
20 ) ) );

    FileOutputStream fileOut =3D new FileOutputStream( "workbook.xls" );
    wb.write( fileOut );
    fileOut.close();

Hope this helps
Nidhi

-----Original Message-----
From: Meghana [mailto:sy62k@yahoo.com]=20
Sent: Tuesday, June 06, 2006 3:40 PM
To: poi-user@jakarta.apache.org
Subject: Multi line text

Hi,
   Does any one know how to out put the text in multiple lines in a
cell? In each row only two cells will have large text running into
multiple lines.=20

Any help is appreciated,
Thanks,
-M

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/