Add borders to cells in POI generated Excel File

Question

I am using POI to generate an Excel File   I need to add borders to specific cells in the worksheet     How can I accomplish this

User · Accepted Answer

Setting up borders in the style used in the cells will accomplish this   Example   style setBorderBottom HSSFCellStyle BORDER MEDIUM   style setBorderTop HSSFCellStyle BORDER MEDIUM   style setBorderRight HSSFCellStyle BORDER MEDIUM   style setBorderLeft HSSFCellStyle BORDER MEDIUM

User · Answer

HSSFCellStyle style workbook createCellStyle    style setBorderBottom HSSFCellStyle BORDER THIN   style setBorderTop HSSFCellStyle BORDER THIN   style setBorderRight HSSFCellStyle BORDER THIN   style setBorderLeft HSSFCellStyle BORDER THIN

User · Answer

To create a border in Apache POI you should     1  Create a style  final XSSFCellStyle style   workbook createCellStyle      2  Then you have to create the border  style setBorderBottom  new XSSFColor new Color 235 235 235       3  Then you have to set the color of that border  style setBottomBorderColor  new XSSFColor new Color 235 235 235      4  Then apply the style to a cell  cell setCellStyle style

User · Answer

In the newer apache poi versions   XSSFCellStyle style   workbook createCellStyle    style setBorderTop BorderStyle MEDIUM   style setBorderBottom BorderStyle MEDIUM   style setBorderLeft BorderStyle MEDIUM   style setBorderRight BorderStyle MEDIUM

User · Answer

If you re using the org apache poi ss usermodel  not HSSF or XSSF  you can use   style setBorderBottom BorderStyle THIN   style setBorderTop BorderStyle THIN   style setBorderLeft BorderStyle THIN   style setBorderRight BorderStyle THIN     all the border styles are here at the apache documentation

User · Answer

XSSF  BorderStyle  Use XSSFCellStyle BORDER MEDIUM or XSSFBorderFormatting BORDER MEDIUM  both enums refer to the same value    XSSFCellStyle cellStyle   workbook createCellStyle     cellStyle setBorderTop XSSFCellStyle BORDER MEDIUM   cellStyle setBorderRight XSSFCellStyle BORDER MEDIUM   cellStyle setBorderBottom XSSFCellStyle BORDER MEDIUM   cellStyle setBorderLeft XSSFCellStyle BORDER MEDIUM    cell setCellStyle cellStyle     BorderColor  Use setBorderColor XSSFCellBorder BorderSide BOTTOM  XSSFColor  or setBottomBorderColor XSSFColor   equivalent for top  left  right    XSSFCellStyle cellStyle   workbook createCellStyle    XSSFColor color   new XSSFColor new java awt Color 128  0  128     cellStyle setTopBorderColor color   cellStyle setRightBorderColor color   cellStyle setBottomBorderColor color   cellStyle setLeftBorderColor color    cell setCellStyle cellStyle

User · Answer

a Helper function   private void setRegionBorderWithMedium CellRangeAddress region  Sheet sheet            Workbook wb   sheet getWorkbook            RegionUtil setBorderBottom CellStyle BORDER MEDIUM  region  sheet  wb           RegionUtil setBorderLeft CellStyle BORDER MEDIUM  region  sheet  wb           RegionUtil setBorderRight CellStyle BORDER MEDIUM  region  sheet  wb           RegionUtil setBorderTop CellStyle BORDER MEDIUM  region  sheet  wb           When you want to add Border in Excel  then  String cellAddr   A 11  A 17     setRegionBorderWithMedium CellRangeAddress valueOf cellAddr1   sheet

User · Answer

From Version 4 0 0 on RegionUtil-methods have a new signature  For example   RegionUtil setBorderBottom BorderStyle DOUBLE              CellRangeAddress valueOf  A1 B7    sheet

[java] Add borders to cells in POI generated Excel File

Examples related to java

Examples related to excel

Examples related to border

Examples related to apache-poi