[Excel POI] 예제 모음

POI 셀 테두리

http://gnujava.com/board/article_view.jsp?article_no=4087&board_no=3&table_cd=EPAR01&table_no=01

 

POI 셀 병합

http://javafactory.tistory.com/1152

 

POI 모음

http://javafactory.tistory.com/1266

 

셀 가운데 맞춤

XSSFCellStyle cs = workbook.createCellStyle();
cs.setVerticalAlignment(VerticalAlignment.CENTER); // 텍스트 가운데 맞춤
cs.setAlignment(HorizontalAlignment.CENTER); // 콘텐츠 가운데 맞춤

cell = row.createCell(0);
cell.setCellStyle(cs);
cell.setCellValue("셀 가운데 맞춤");