package org.apache.poi.xssf.usermodel.examples;

import java.io.FileOutputStream;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.Font;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class CellNewlines {

    public static void main(String[]args) throws Exception{

	 Workbook wb = new XSSFWorkbook();

	    Sheet s = wb.createSheet();

	    Row r = null;

	   Cell c = null;

	    CellStyle cs = wb.createCellStyle();

	    Font f = wb.createFont();

	    Font f2 = wb.createFont();

	    cs = wb.createCellStyle();

	    cs.setFont( f2 );

	    //Word Wrap MUST be turned on

	    cs.setWrapText( true );

	    r = s.createRow( (short) 2 );

	    r.setHeight( (short) 0x349 );

	    c = r.createCell( (short) 2 );

	    c.setCellType( Cell.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 = new FileOutputStream( "newline_cell.xlsx" );

	    wb.write( fileOut );

	    fileOut.close();

    }

}