Apache POI Excel Cell Border

by Online Tutorials Library July 14, 2022

Apache POI Excel Cell Border

To set border of cell, Apache POI provides methods that can be used to set border color, thin, dashed etc. In the following example, we have created a cell and set border from top to bottom and right. See the example.

Apache POI Excel Cell Border Example

  package poiexample;  import java.io.FileNotFoundException;  import java.io.FileOutputStream;  import java.io.IOException;  import java.io.OutputStream;  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.CellStyle;  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;  public class BorderExample {  public static void main(String[] args) throws FileNotFoundException, IOException {      Workbook wb = new HSSFWorkbook();      Sheet sheet = wb.createSheet(“Sheet”);      Row row     = sheet.createRow(1);      Cell cell   = row.createCell(1);      cell.setCellValue(101);      // Styling border of cell.      CellStyle style = wb.createCellStyle();      style.setBorderBottom(BorderStyle.THIN);      style.setBottomBorderColor(IndexedColors.BLACK.getIndex());      style.setBorderRight(BorderStyle.THIN);      style.setRightBorderColor(IndexedColors.BLUE.getIndex());      style.setBorderTop(BorderStyle.MEDIUM_DASHED);      style.setTopBorderColor(IndexedColors.BLACK.getIndex());      cell.setCellStyle(style);      try (OutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {          wb.write(fileOut);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Next TopicApache POI Excel Cell Color

Apache POI Excel Cell Border

Apache POI Excel Cell Border

Apache POI Excel Cell Border Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like