Apache POI Excel Align Cell

by Online Tutorials Library July 14, 2022

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(“tutoraspire.xls”)) {          Sheet sheet = wb.createSheet(“New Sheet”);          Row row = sheet.createRow(0);          Cell cell = row.createCell(0);          cell.setCellValue(“tutoraspire”);          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:

Next TopicApache POI Excel Cell Border

Apache POI Excel Align Cell

Apache POI Excel Align Cell

Apache POI Excel Align Cell Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like