Apache POI Excel Cell Properties

by Online Tutorials Library July 14, 2022

Apache POI Excel Cell Properties

Sometimes we want to create a spreadsheet with basic styles and then apply special styles to certain cells such as drawing borders around a range of cells or setting fills for a region. Apache POI provides CellUtil.setCellProperties which allows us to do that without creating a bunch of unnecessary intermediate styles in our spreadsheet.

Properties are created as a Map and applied to a cell.

Lets see an example in which we are applying special styles to certain cell.

Apache POI Excel Cell Properties Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import java.util.HashMap;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.BorderStyle;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.IndexedColors;  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.ss.util.CellUtil;  public class CellPropertiesExample {  public static void main(String[] args) {  try (OutputStream os = new FileOutputStream(“tutoraspire.xls”)) {   Workbook workbook = new HSSFWorkbook();   Sheet sheet = workbook.createSheet(“Sheet”);   HashMap properties = new HashMap();   // Set border around the cell   properties.put(CellUtil.BORDER_TOP, BorderStyle.MEDIUM);   properties.put(CellUtil.BORDER_BOTTOM, BorderStyle.MEDIUM);   properties.put(CellUtil.BORDER_LEFT, BorderStyle.MEDIUM);   properties.put(CellUtil.BORDER_RIGHT, BorderStyle.MEDIUM);   // Set color Red   properties.put(CellUtil.TOP_BORDER_COLOR, IndexedColors.RED.getIndex());   properties.put(CellUtil.BOTTOM_BORDER_COLOR, IndexedColors.RED.getIndex());   properties.put(CellUtil.LEFT_BORDER_COLOR, IndexedColors.RED.getIndex());   properties.put(CellUtil.RIGHT_BORDER_COLOR, IndexedColors.RED.getIndex());   // Apply the borders to the cell   Row row   = sheet.createRow(2);   Cell cell = row.createCell(2);   CellUtil.setCellStyleProperties(cell, properties);   // Apply the borders to a 3×3 region starting at D4   for (int i=3; i <= 5; i++) {     row = sheet.createRow(i);     for (int j = 3; j <= 5; j++) {       cell = row.createCell(j);       CellUtil.setCellStyleProperties(cell, properties);     }   }   workbook.write(os);  }catch(Exception e) {  System.out.println(e.getMessage());  }  }  }  ,>,>

Output:

Next TopicApache POI Drawing Border

Apache POI Excel Cell Properties

Apache POI Excel Cell Properties

Apache POI Excel Cell Properties Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like