Apache POI Excel Align Cell

Apache POI helps to align cell and it's content in certain manner. We can set cell's height and width & align it top or bottom. The Sheet class provides methods to set height and width.

Lets see an example in which we are creating a cell an aligning it as well.

Apache POI Excel Align Cell Example

package poiexample;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
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.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;

public class AlignExample {
	public static void main(String[] args) throws FileNotFoundException, IOException {
		Workbook wb = new HSSFWorkbook();
	    try  (OutputStream os = new FileOutputStream("Javatpoint.xls")) {
	        Sheet sheet = wb.createSheet("New Sheet");
	        Row row = sheet.createRow(0);
	        Cell cell = row.createCell(0);
	        cell.setCellValue("Javatpoint");
	        CellStyle cellStyle = wb.createCellStyle();
	        row = sheet.createRow(5); 
	        cell = row.createCell(0);
	        // Top Left alignment 
	        HSSFCellStyle style1 = (HSSFCellStyle) wb.createCellStyle();
	        sheet.setColumnWidth(0, 8000);
	        cell.setCellValue("Top Left");
	        cell.setCellStyle(style1);
	        row = sheet.createRow(6); 
	        cell = row.createCell(1);
	        row.setHeight((short) 800);
	        wb.write(os);
	    }catch(Exception e) {
	    	System.out.println(e.getMessage());
	    }
	}

}

Output: