HSSF setborderbottom doesn't work last excel cell

Asked Nov 14 '19 at 12:53

Active Nov 14 '19 at 12:57

Viewed 219 times

I am using POI to generate an Excel File. I need to add borders to all cells , i made a for loop i was able to add borders to all cells but not the last cells of the last row .

HSSFCellStyle cellStyleAllF = null;
cellStyleAllF = wb.createCellStyle();
cellStyleAllF.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyleAllF.setVerticalAlignment(HSSFCellStyle.ALIGN_LEFT);
cellStyleAllF.setBorderTop(HSSFCellStyle.BORDER_THIN);
cellStyleAllF.setTopBorderColor(HSSFColor.BLACK.index);
cellStyleAllF.setBorderRight(HSSFCellStyle.BORDER_THIN);
cellStyleAllF.setRightBorderColor(HSSFColor.BLACK.index);
cellStyleAllF.setBorderBottom(HSSFCellStyle.BORDER_THIN);
cellStyleAllF.setBottomBorderColor(HSSFColor.BLACK.index);
cellStyleAllF.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cellStyleAllF.setLeftBorderColor(HSSFColor.BLACK.index);

edited Nov 14 '19 at 12:57

deHaar

17,687
10
38
51

asked Nov 14 '19 at 12:53

Othmane Mjhd

1

The 2 cells left of the marked ones seem to have the proper border – XtremeBaumer Nov 14 '19 at 13:05
Yes apparently , but the ones i spoted they don't – Othmane Mjhd Nov 14 '19 at 13:31
Show your code man – Fizik26 Nov 18 '19 at 14:14

HSSF setborderbottom doesn't work last excel cell

0 Answers0